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

SanjivMeher · ‎04-26-2018

You can build a report on sysapproval_approver table.

Filter should be Source Table = Request OR Source Table = Requested Item.

Please mark this response as correct or helpful if it assisted you with your question.

Daniel Peel · ‎04-26-2018

This doesn't work for what I'm looking for...

I need to have a report that shows something like this...

but adding to this... who approved the REQ as well.

this is the column setup I've used.

and the filter.. I can't get that other piece of data

SanjivMeher · ‎04-26-2018

Something like this? Can you post the complete report with the fields and filter

Please mark this response as correct or helpful if it assisted you with your question.

Daniel Peel · ‎04-26-2018

I have posted that... above... the new UI doesn't show all that in a single view. You are missing who approved the REQ... you are only listing the approver for the RITM. I need both approvals.