Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Not seeing data in Database View??

wdookie
Mega Contributor

I am currently working on a Database View, so I can do a report.   The report consists of data from 3 tables (pm_project, pm_project_task and time_card).   My database view that I am playing with consists of the following View Tables:

 

find_real_file.png

 

On the project task table I am matching the task number to the task number on the time card table.

 

On the project table I am matching the Project Number to the Project Number on the Project Task Table.

 

My Left Join criteria I have set all to true, since right now this is the only way I am getting data back.   However, the 81 data records   I am getting back looks like junk:

 

find_real_file.png

 

Fields are blank, or they say, false, UNKNOWN, (empty)...

 

I know I am doing something fundamentally wrong here.   Any guidance will be GREATLY appreciated.

 

Thanks!!!!!!

6 REPLIES 6

Yeah... sys_id worked for me too. Thanks a lot!!


Under your "Order", make sure they are also different numbers EG, 100, 200, 300. From what I have read and created, they should also be unique.