Adding RITM Variable Filter in Report from sysapproval_approver

[zee15]

Hi,

I have created a report on the sysapproval_approver table for a specific catalog item to track approvals pending for more than 3 days. The report is working fine, but I need to refine it further.

Currently, it shows all approval records, but I want to add an additional filter based on a variable from the RITM (requested item). However, I am unable to use the RITM variable in the report filter.

does anyone know how to achieve this? Any guidance would be greatly appreciated!

Thanks,

[Dr Atul G- LNG]

 Hi @zee15 

I tried in my PDI and it is not possible. Give a try to create a database view approval & RITM table, then it may work.

[Ankur Bawiskar]

@zee15 

check this

Showing RITM variable, in the list view of a report that is referencing sysapproval_approver table 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@zee15 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@zee15 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.