Approval script

[akin9]

Hello Experts,

We want to create a reminder email notification for pending approval "SC_REQ_ITEM".

Requirment

1.want to give a reminder email every 7 days till 60 days from created.If any RITM is pending for approval.

2. if above conditions are met "Request - Reminder" notification needs to be sent 

how to add the notification on the script?

we have tried below script using scheduled job but not working .

or else can we achieve any other ways?. kindly support.

Spoiler

Spoiler

var ritm = new GlideRecord('sc_req_item');
var encQuery = 'active=true^state=1'; //1 is state pending approval;
ritm.addEncodedQuery(encQuery);
ritm.query();

while (ritm.next()) {

var chkApprvl = new GlideRecord('sysapproval_approver');
chkApprvl.addQuery('document_id', ritm.sys_id);//find the approval related to this item
chkApprvl.addQuery('state', 'requested');//its state should be requested
chkApprvl.addQuery('sysapproval.sys_class_name','sc_req_item');
chkApprvl.addQuery('sys_updated_onRELATIVELE@dayofweek@ago@7'); //this checks if the approval has not be updated for 7 days

chkApprvl.query();

while(chkApprvl.next()) {

ritm.work_notes = 'Reminder email to approver sent after 7 days.';
ritm.update();
}
}

[Ankur Bawiskar]

@akin9 

what debugging have you done so far?