Hi,
Sample email script if your email notification is on sysapproval_approver table
And you want to show sc_task attachment
Email Script:
Name:show_attachments_task_record
Script:
(function runMailScript(current, template, email, email_action, event) {
// Add your code here
// get attachment for all SC Tasks belonging to the RITM present for this Approval Record
var sc_taskRecord = new GlideRecord('sc_task');
sc_taskRecord.addQuery('request_item', current.sysapproval);
sc_taskRecord.query();
while(sc_taskRecord.next()){
var gr = new GlideRecord('sys_attachment');
gr.addQuery('table_sys_id', sc_taskRecord.getUniqueValue());
gr.query();
if (gr.hasNext()) {
template.print("Attachments: <br />");
while (gr.next()) {
var url = gr.getTableName() + ".do?sys_id=" + gr.getValue('sys_id');
var attachLink = '<a href="' + url + '">' + gr.file_name + '</a>';
template.print(attachLink + "<br />");
}
template.print("<hr/>");
}
}
})(current, template, email, email_action, event);
Include in your notification like this ${mail_script:show_attachments_task_record}
Regards
Ankur
Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
