Need to query RITM with the current approvers

[Ken Berger]

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

[Jaspal Singh]

Hi Ken,

You need to report on the Approver (sysapproval_approver) table and then dot-walk as below.

This will help you get fields from RITM table and also the Approval status from Approval table.

[Ken Berger]

Hi Jaspal,

Thanks for your reply.  Can this be done in a query?  When I try to query the sysapproval_approver table, I do not get the related fields from the RITM.

Thanks,

Ken

[Jaspal Singh · Accepted solution]

You need to dot-walk. Approval For >> Task fields and then locate the options as suggested in above screen

[Danish Bhairag2]

Hi @Ken Berger ,

You can directly query the Approver (sysapproval_approver) table & get the data (approver's) name & send them a reminder asking them to take action. U can write a fix or scheduled script for this.

var gr = new GlideRecord('sysapproval_approver');
gr.addEncodedQuery('state=requested^approver!=NULL^sysapproval.numberSTARTSWITHRITM');
gr.query();
while(gr.next()){
    gs.eventQueue('send.reminder',gr,gr.approver);
}

Create a Notification on Approver table which triggers when event is fired & check on sysparm event 1 checkbox under whom to send.

Thanks,

Danish