Searching for a list of what a user can approve

ellisona
Kilo Explorer

I have been asked to change a user so they can replace a current user approvals with the Catalogue.   They do not know which items or where they approve, so I am looking to see if there is somewhere I can report on a user and where they are in the approval process globally without looking at each Catalogue item?

1 REPLY 1

m_ahmedmod
Giga Contributor

Hi Andrew,



You could try reporting on the 'Approval (sysapproval_approver)' table and search against the 'Approver' column along with, 'Approval for', 'Approving' and 'Group'. This should give you an idea of which approvals have been requested of the user and for which specific items, but you will have to run through them to understand at what point they were raised.



You might have a solution already but I'll add this for anyone looking for anything similar.