- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2023 01:57 PM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2023 02:02 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2023 02:02 PM
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