Approval Comments on Task list view

[Community Alums]

Hi Team,

I want to show the Approval comments added while approving the task on the task list view as of now I can only see Approval history field which give complete approval history but I want the latest one on the task list view is it possible?

Thanks,

Prudhvi

[Nilesh Pol · Accepted solution]

@Community Alums Yes, you can display the latest approval comments on the task list view in ServiceNow, but it requires a bit of configuration since this data comes from the related sysapproval_approver table, not directly from the task itself.

Create a new field on the task table (e.g., Latest Approval Comment).

• Type: String

• Mark it as Calculated.

  • Use this calculated script:

var comment = '';
var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('sysapproval', current.sys_id);
gr.orderByDesc('sys_updated_on');
gr.setLimit(1);
gr.query();
if (gr.next()) {
comment = gr.comments;
}
answer = comment;

finally, Add this field to your list layout in the list view.

[Nilesh Pol]

@Community Alums Did you verified the this response, let us know what challenge you are facing?

[Community Alums]

Hi @Nilesh Pol , Thanks for the response, currently I am trying your suggestion will share the output

[Ankur Bawiskar]

@Community Alums 

RITM is approved/rejected by approver and not task record.

what's your exact requirement?

If my response helped please mark it correct and close the thread so that it benefits future readers.