Hello,
We have a notification that triggers on the sysapproval_approver table. If a comment is added to the RITM record, we would like to capture it in the notification. We have tried the following code, but it did not work. Can someone please help? Thank you.
(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */
email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */
event) {
var ritm = new GlideRecord('sc_req_item');
if (ritm.get(current.request_item)) {
// 'ritm' now contains the related RITM record
var comments = [];
var commentGr = new GlideRecord('sys_journal_field');
commentGr.addQuery('element_id', ritm.sys_id);
commentGr.addQuery('element', 'comments');
commentGr.query();
while (commentGr.next()) {
comments.push(commentGr.value);
}
template.print(commentGr.value);
}
})(current, template, email, email_action, event);
