How to get approval comments post-approval

[Sanjay Rallapal]

Hello all,

I need to collect all comments and the actors making the comments (and their decisions). I am using the following script based on 

https://www.servicenow.com/community/itsm-forum/copy-approval-comments-to-sctask-work-notes/td-p/725...

// Get all approvers and comments
var arr = [];
var apv = new GlideRecord('sysapproval_approver');
apv.addQuery('sysapproval', current.sys_id);
apv.query();
while (apv.next()) { // Go through all approvals with comments
arr.push("Approval Comments: from " + apv.approver.name + "\n" + apv.comments.getJournalEntry(-1));
}
var approver_hist = arr.join('\n');
gs.log("Approver History: "+ approver_hist,"RITM Post Approval Info");

The log shows the approver name but not the comments. What am I doing wrong?

[Ravi Gaurav]

Hi @Sanjay Rallapal 

The issue you're encountering where the log shows the approver name but not the comments likely occurs because the getJournalEntry(-1) method is used incorrectly. The getJournalEntry method is typically used to fetch a specific journal entry by index, and -1 refers to the latest journal entry. However, this method might not return the expected result if the comments field is a journal field.

Instead of using getJournalEntry(-1), you should access the journal field using the comments object and iterate through the journal entries to retrieve all comments. Here's how you can modify your script to collect the approver's comments correctly:

// Get all approvers and comments
var arr = [];
var apv = new GlideRecord('sysapproval_approver');
apv.addQuery('sysapproval', current.sys_id);
apv.query();
while (apv.next()) { // Go through all approvals with comments
var comments = apv.comments.getJournalEntries(); // Get all journal entries for the comments field
var approverHistory = "Approval Comments: from " + apv.approver.name;

// Iterate through each comment entry
comments.forEach(function(entry) {
approverHistory += "\n" + entry;
});

arr.push(approverHistory);
}

var approver_hist = arr.join('\n');
gs.log("Approver History: " + approver_hist, "RITM Post Approval Info");

[Sanjay Rallapal]

Hello @Ankur Bawiskar @Ravi Gaurav @lehiyis5 

Thank you all for your help. With your help, I was able to capture the comments.
var scReqItemId = current.sys_id;
var arr = [];
var apv = new GlideRecord('sysapproval_approver');
apv.addQuery('sysapproval',scReqItemId);
apv.query();
while (apv.next()) { // Go through all approvals with comments
var approverHistory = "Approval Comments: from " + apv.approver.name;
var commentGr = new GlideRecord('sys_journal_field');
commentGr.addQuery('element_id', scReqItemId);
commentGr.addQuery('element', 'comments');
commentGr.orderBy('sys_created_on');
commentGr.query();
while(commentGr.next()){
approverHistory += commentGr.value.toString();
}
arr.push(approverHistory);
}