here is a sample, you can add more conditions and refine it as needed
(function executeRule(current, previous /*null when async*/) {
var grec = new GlideRecord("change_request");
grec.addQuery("sys_id", current.sysapproval);
grec.query();
if (grec.next()) {
grec.work_notes = 'Action by = '+current.approver.getDisplayValue() ;
grec.update();
}
})(current, previous);
Hi @Nagurbee1 ,
Please follow the steps below that I've completed for the change request table. You can replace the change request with the case table in the GlideRecord object.
Establish a business rule on the sysapproval_approver table that activates when the state changes to either approved or rejected.
In the script, we will use GlideRecord to ensure that the changes apply exclusively to the specified table and will update the work notes accordingly.
Output :
You can modify the business rule condition according to your needs; this is just an example of how to achieve your requirements.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If you found my response **helpful**, I’d appreciate it if you could take a moment to select **"Accept as Solution"** and **"Helpful"** Your support not only benefits me but also enriches the community.
Thank you!
Moin Kazi
www.linkedin.com/in/moinuddinkazi
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
here is a sample, you can add more conditions and refine it as needed
(function executeRule(current, previous /*null when async*/) {
var grec = new GlideRecord("change_request");
grec.addQuery("sys_id", current.sysapproval);
grec.query();
if (grec.next()) {
grec.work_notes = 'Action by = '+current.approver.getDisplayValue() ;
grec.update();
}
})(current, previous);
