Not seeing data in Database View??
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-13-2014 08:55 AM
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:
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:
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!!!!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2014 10:44 AM
Yeah... sys_id worked for me too. Thanks a lot!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-20-2014 04:53 AM
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.