Database view to see Approvals

[Shree Nag]

Hello All.

I have created database view to include sc_req_item, sc_request and sysapproval_approver to get a list of pending approvals in a report.

Attached is the image of the tables and the joins. When I "Try It" I get no records.

Please help me find what could be wrong on the join.

Thank you in advance.

-Shree

[Brad Bowman · Accepted solution]

The Where clause on the third table join should be app_sysapproval=ritm_sys_id since the approval record references the RITM record, not the REQ