Scheduled Script Issue

[Johny1]

Hi,

I have a requirement to send 3 approval reminders each a week apart and the request should auto cancel after 3 reminders.

Here I have configured using scheduled job.

How can I send the remaining 2 reminders using the same scheduled job script.

var scApp = new GlideRecord('sysapproval_approver');
scApp.addEncodedQuery('state=requested^sysapproval.sys_class_name=sc_req_item^sys_created_onRELATIVELE@dayofweek@ago@7');
scApp.query();
while(scApp.next()){
	
	gs.eventQueue('sc_reminder1',scApp,scApp.approver);
	
}

[AirSquire]

Hi Johny,

Remove the below part from encoded query

sys_created_onRELATIVELE@dayofweek@ago@7

Inside while loop put three conditions and trigger the corresponding events for them. Sample script below:

while (scApp.next()){
if (scApp.sys_created_on <= gs.daysAgo(7)){
gs.eventQueue('sc_reminder1',scApp,scApp.approver);
}

else if (scApp.sys_created_on <= gs.daysAgo(14)){
gs.eventQueue('sc_reminder2',scApp,scApp.approver);
}

else if (scApp.sys_created_on <= gs.daysAgo(21)){
gs.eventQueue('sc_reminder3',scApp,scApp.approver);
}
}

Regards
Air

[Johny1]

Thank you Air.

How can I cancel the request after 3 reminder please.

[AirSquire · Accepted solution]

while (scApp.next()){
if (scApp.sys_created_on <= gs.daysAgo(7)){
gs.eventQueue('sc_reminder1',scApp,scApp.approver);
}

else if (scApp.sys_created_on <= gs.daysAgo(14)){
gs.eventQueue('sc_reminder2',scApp,scApp.approver);
}

else if (scApp.sys_created_on <= gs.daysAgo(21)){
gs.eventQueue('sc_reminder3',scApp,scApp.approver);

var item = new GlideRecord('sc_req_item');
item.addQuery('sys_id',scApp.sysapproval);
item.addEncodedQuery('state!=numeric_value_for_cancel');
item.query();

if(item.next()){
item.state = numeric_value_for_cancel;
item.update();
}

//also update the state of approval record
scApp.state = 'cancelled';
scApp.update();
}
}

Regards
Air

[Johny1]

Thanks a lot Air. 🙂