Hi all,
I am trying to query all open requests for a particular item, where approval has been requested but there has been no action (approve or reject), and I need to get the name of the person that is waiting to approve/reject the request. I can filter the Requested Items table but I do not see how to get the approver (seems this is calculated in the RITM form but not on the table or any related lists).
Is there any way to pull this data? I want to send out notices to the folks who have not yet taken any approval action on these RITM's so that we can clean up some old requests.
Thanks,
Ken
