Approval Comments on Task list view

Community Alums
Not applicable

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

1 ACCEPTED SOLUTION

Nilesh Pol
Tera Guru

@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.

 

View solution in original post

6 REPLIES 6

Community Alums
Not applicable

Hi @Ankur Bawiskar , I have custom application where I have a custom table as parent table and an extended table from task which will hold the child task and these child task will have the approvals attached on this task list I want to show the approval comments

@Community Alums 

then no other way but to create a custom string field to hold the approval comment

Populate that when task is approved

Then add this field in the list layout of task table you want

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader