Help with Database View Where Clause

[Still Learning]

Hello SN Community,

I am trying to map three tables and create a database view to build a dashboard. The issue I am encountering is that the list view is empty when I attempt to try my database view.  There are more than 2,000 records associated with each table so the list should not be empty.  

The three tables I am mapping are: 

pm_project (left join),  project_status, and pm_project_task ... each table has a list of fields but I don't believe that is the problem. I'm thinking the issue is with my where clause.  Can someone please tell me what I am doing wrong?? My table mappings are below.

[Aman Kumar S · Accepted solution]

instead of number try using sys_id

stat_project = prj_sys_id

task_parent = prj_sys_id

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

[Still Learning]

Hello Aman, 

Thank you so much for your reply!! Your where clauses DID produce a list!!! The problem, however is that it only returned 24 records whereas each table has more than 2,000 records. I'm working in a DEV instance, but I'm thinking that I should see more records than I'm seeing (??) Am I missing something?

[Aman Kumar S]

DId you set left join field as true in the view table list, if not bring the column in the list and mark as true for Project status and project task table

[Still Learning]

That definitely helped. It brought in 100 records that way, I think the real issue is that not all of the records on the status project are actually mapped to a project - but I should see all of the project tasks come in though, correct?