I have the following mail script for Change Approval Reminders:
//First, we need to locate our current user's approvals (the parm1 variable contains the current approver)
var app = new GlideRecord('sysapproval_approver'); //create a query to retrieve open approvals
app.addQuery('state','requested'); //only retrieve approvals that are pending
app.addQuery('approver',event.parm1); //only find approvals for the current approver
app.addQuery('sysapproval.sys_class_name','change_request'); //only find approvals for change reqeusts
app.query();
while(app.next()){
//now that we have an approval for that user, we are going to look up the change tickets they need to approve and print out the data
var chg = new GlideRecord('change_request'); //find the first related Change approval and print info
chg.get(app.sysapproval);
template.print('<p>You have an open change approval for ' + chg.number + '</br>');
template.print('<b>Description:</b> ' + chg.short_description + '</br>');
template.print('<b>Scheduled date:</b> ' + chg.work_start + '</p>');
}
I would like to make the chg.number a clickable link. I am unable to do so with ${URI_REF}. I would rather not have a separate link that says click here and instead have the CHG number itself clickable (Screenshot below). Any help?
Paul, thanks this was great as the link is now being generated. I do want the link to point to the Approval and note the Change itself however now it prints the same Change Number for each link. My original notification email looked like this:
I have modified the script to:
//First, we need to locate our current user's approvals (the parm1 variable contains the current approver)
var app = new GlideRecord('sysapproval_approver'); //create a query to retrieve open approvals
app.addQuery('state','requested'); //only retrieve approvals that are pending
app.addQuery('approver',event.parm1); //only find approvals for the current approver
app.addQuery('sysapproval.sys_class_name','change_request'); //only find approvals for change reqeusts
app.query();
while(app.next()){
//now that we have an approval for that user, we are going to look up the change tickets they need to approve and print out the data
var chg = new GlideRecord('change_request'); //find the first related Change approval and print info
chg.get(app.sysapproval);
template.print('<p>You have an open change approval for ' + '${URI_REF}' + '</br>');
template.print('<b>Description:</b> ' + chg.short_description + '</br>');
template.print('<b>Scheduled date:</b> ' + chg.work_start + '</p>');
}
Now my notification e-mail looks like this:
