How to add a change task table in change email notification in workflow?
| Image | Description |
 | 01. Go to >> System Notification > Notification Email Scripts |
 | 02. New |
 | 03. Type a name |
 |
04. Type script following the sample code above using the ordinary GlideRecord and creating a HML table. |
|
05. On the notification you need to use a sample code, using the format ${mail_script:<scriptname>}
${mail_script:type_the_script_name} |
Script
(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
var vchange = current.sys_id;
var vtask = new GlideRecord('change_task');
vtask.addQuery('change_request',vchange);
vtask.query();
template.print('<table border="1">');
template.print('<tbody>');
template.print('<tr>');
template.print('<td style="text-align: center; color: #ffffff; background-color: #002060;">TASK </td>');
template.print('<td style="text-align: center; color: #ffffff; background-color: #002060;">Assignee</td>');
template.print('<td style="text-align: center; color: #ffffff; background-color: #002060;">STATUS</td>');
template.print('<td style="text-align: center; color: #ffffff; background-color: #002060;">Close notes</td>');
template.print('</tr>');
while(vtask.next()){
template.print('<tr>');
template.print('<td>'+vtask.short_description+'</td>');
template.print('<td>'+vtask.assigned_to.name+'</td>');
template.print('<td>'+vtask.state+'</td>');
template.print('<td>'+vtask.close_notes+'</td>');
template.print('</tr>');
}
template.print('</tbody>');
template.print('</table>');
})(current, template, email, email_action, event);
Governance: Technical Best Practices eBook
