Mail Script URI Link Help

[shawhan1126]

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?

[justin_drysdale]

Assuming you can pass the sys_id along with the change number, you can use a function to build the link:

//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 ' + buildLink(chg.number.toString(), chg.sys_id.toString()) + '</br>');

template.print('<b>Description:</b> ' + chg.short_description + '</br>');

template.print('<b>Scheduled date:</b> ' + chg.work_start + '</p>');



function buildLink(n, sid) {

   var s = 'https://YOURINSTANCE.service-now.com/';

           s += 'nav_to.do?uri=change_request.do%3Fsys_id=';

           s += sid;

   var link = "<a href='" + s + "'>" + n + "<\a>";

   return link;

}

}