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-27-2018

You can always switch to classic view to go to the single page view.

Also you dont see the approved once, because I didn't have one. Below is a screenshot with approved one.

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

Daniel Peel · ‎04-27-2018

If this helps... and you are showing the approval for the RTIM... I need the approval for the RITM and the approval for the REQ on the same report. I need to report on the approval's associated with the whole REQ. If an REQ has 4 RITMs on it, I need to show The REQ - who approved it and the 4 RITMs and who approved those. I know this will be 4 lines and that's fine as I could group by the REQ.

SanjivMeher · ‎04-27-2018

You can use the below filter and I am sure it will work. I dont have such data, so I am not able to generate this kind of report

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

Daniel Peel · ‎04-27-2018

Sadly it does not, I can not create that report. Our REQs are meant as holders for one or more RITMs, OOB construct. The REQs do not have a category on them. If I sort that using the RITM category the REQs will not be in the report. I need to do something that lets me look in the sysapproval_approver using the RITM and another piece of data that pulls the REQ associated with that RITM. Since the category doesn't exist on the REQ table, you are effectively eliminating anything in your data where the source table is sc_request.

SanjivMeher · ‎04-27-2018

Yes. The scenario where approval is on Request, you wont be able to pull those data based on category.

You will need something on the Request table using which you can filter.

The other option, which is a difficult one is creating a database view between approval table, Request table and Requested Item table.

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