Database view to see Approvals

Shree Nag
Tera Expert

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

 

1 ACCEPTED SOLUTION

Brad Bowman
Kilo Patron
Kilo Patron

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

View solution in original post

1 REPLY 1

Brad Bowman
Kilo Patron
Kilo Patron

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