How can I capture comment made in ritm using email script?

[Erica2]

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);

[Saurabh Gupta]

Hi,
Change the below statement to

template.print(commentGr.value); to template.print(comments.join(","));

[Erica2]

Hello @Saurabh Gupta  

I made a mistake. I need help retrieving the work notes that were added to the RITM record on to the notification that triggered on the sysapproval_approver table.  Could you please help?  Thanks

[Maik Skoddow · Accepted solution]

Hi @Erica2 

please use the short notation:

template.print(current.sysapproval.comments.getJournalEntry(1));

 Maik

[Erica2]

Hello @Maik Skoddow 

I think I made a mistake somewhere in the code that made it print "blank"

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(current.sysapproval.comments.getJournalEntry(1));
}