I am really need of some expert suggestions.
User want to have notifications for the current assigned approver(s) of requests sent every 5 days until the approver responds to the request or the ticket is closed.
Workflow:
Hi,
Please find the steps below to achieve your requirement:
1) Navigate to "Registry" module and create a event as below:
2) Select table as sysapproval_approver as shown below:
3) Navigate to the module "Scheduled Job" under System Definition and select Automatically run a script and use the script below:
Script for reference:
sendNotif();
function sendNotif(){
var gr = new GlideRecord('sysapproval_approver');
gr.addEncodedQuery('state=requested^sys_created_onRELATIVELT@dayofweek@ahead@5^source_table=sc_req_item'); // Replace "sc_req_item" with the Table for which you want to trigger notification
gr.query();
while(gr.next()){
gs.eventQueue('send.notif',gr,gr.approver); // "send.notif is the Event name configured in step 1. Also, "gr.approver" replace it with the recipient to whom you want to trigger.
}
}
Scheduled Job Frequency:
Now finally configure your notification and make sure to make it event based and check the parameter "parm1 and send to event creator as tru as shown below:
Notification will be on Approval table:
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
Hi Tina,
Refer to the below article:
Now the above article is common to approvals from all the tables. so for the Trigger Condition you need to add some additional conditions so that it will be triggered only to your sc_request or sc_req_item table.
In the above screenshot, I have set the trigger to run only for the sc_request and sc_req_item table. you can configure it as per your need.
Please mark it as Correct/Helpful If my answer is helpful in any way,
Best regards,
Thameem
Hi Thameem,
Thanks for your suggestion, how to set it send notification every 5 days?
"User want to have notifications for the current assigned approver(s) of requests sent every 5 days until the approver responds to the request or the ticket is closed."
