'Comments' in email notification

Riya17
Giga Contributor

Hi,

I have a requirement to show 'comments' in the request rejection email notification.  At the moment the script is not working.  It just shows blank space for 'Comments'.  Below is my notification, template and the script.   Could someone help me where it's going wrong.

Thank you 

 

Notification:

 

find_real_file.png

 

Template:

find_real_file.png

email script:

var comment = new GlideRecord("sysapproval_approver");
comment.addQuery("sysapproval", current.sys_id);
comment.query();
while (comment.next()) {
var comments = rec.comments.getJournalEntry(1);
template.print("<b>Comments:</b>" + comments + "\n");
template.print("<b>Comments:</b>" + comments.substring(comments.indexOf("\n")+1) + "\n");
}

 

 

15 REPLIES 15

Brad Tilton
ServiceNow Employee
ServiceNow Employee

I think the issue is with this line:

var comments = rec.comments.getJournalEntry(1);

What is the rec referring to? If you want comments from the approval table you'll need to use the comment GlideRecord object you've defined instead and if you want comments from the request table you'd use current.

Riya17
Giga Contributor

Sorry, that was a typo.  It's actually,

 

var comments = current.comments.getJournalEntry(1);

Brad Tilton
ServiceNow Employee
ServiceNow Employee

So is your goal to take the comments from the request and put them in the email, or the comments from the approval? If it's the current request then you shouldn't need to do your gliderecord query on the approval table.

Riya17
Giga Contributor

I have to get 'Comments' from the approval.