Report on approvers for REQ and all RITMs attached

Daniel Peel · ‎04-26-2018

I'm looking for a way to pull a report that shows an REQ's approver and any RITM approvers related to it. Columns I'd need are

REQ, RITM, REQ Approver RITM Approver Requested for

I know req would be duplicated... any ideas?

I tried from sysapproval_approver and I can get one or the other but not both.

Thanks

kevinray · ‎09-05-2018

Hi Daniel,

I just came across your post. This should work for you

- Create a new Database View

- Name: Approvals_With_Detail

- Label: Approvals With Detail

- Plural: Approvals With Details

[Insert & Stay]

- Click "New" On View Tables related list which now appears at the bottom

1) TABLE: sc_req_item, ORDER: 100; VARIABLE PREFIX: ritm; WHERE CLAUSE: [leave blank]

2) TABLE: sc_cat_item, ORDER: 200; VARIABLE PREFIX: cat; WHERE CLAUSE: ritm_cat_item=cat_sys_id

3) TABLE: sysapproval_approver, ORDER: 300; VARIABLE PREFIX: appr; WHERE CLAUSE: appr_sysapproval=ritm_sys_id

Use this view in a report and you should now have available to you all the fields from the request item, the catalog item, the approval, and fields from the Request (Using "Parent+" option on your fields) should be available to you.

View solution in original post

Troya1 · ‎12-04-2019

Used this solution to create relationship directly to request vs requested_items.

Thanks for sharing