This is how I do it. If anyone else has a shorter, better way, do share.
Create a BR that checks the state of the approval. If state is Requested, generate an event which will trigger a notification. The BR will run daily using a scheduled job (you can do it directly from the job, but I like business rules on the same table).
1. BR:
Name: Email reminder to approver
Table: Approval [sysapproval_approver]
When to run: after
Script:
// run by a scheduled job by the same name
(function executeRule(current, previous /*null when async*/) {
// Add your code here
var elapsedTime = 0;
var currentTimeNow = gs.nowDateTime();
var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('state', '=', 'requested');
gr.query();
while(gr.next()) {
elapsedTime = (gs.dateDiff(gr.sys_created_on, currentTimeNow, true)) /60/60/24; //this will check if the approval request was created more than 24 hours prior to checking
if (elapsedTime >= 1) {//if more than one day has passed...
gs.eventQueue('this.approval.reminder', gr, gs.getUserID());//fire this event
}
}
})(current, previous);
2. create a registry entry for this.approval.reminder on table sysapprover_approval
3. create a notification to be sent upon firing the registry event
Table: sysapproval_approver
When to run: event is fired
Name of event: this.approval.reminder
Who will receive: approver
What it will contain: whatever you want it to contain
4. create a scheduled job:
name: Email reminder to approver
Script:
fcScriptName=Email reminder to approver --> this needs to be the same name as the BR
Trigger type: daily or whatever you need it to be
harel
