Need to get approver name from sysapproval_approver table

[Snowman10]

Hello Community, 

I want to mention the approver's name in my notification. 

For example, The table of the notification is on the Onboarding table. I want to mention the approver's name on the notification's content. Kindly help me to do it. 

Thanks & Regards 

[priyasunku]

Hi @Snowman10 

You can write an email script to get approver name 

Var gr = new GlideRecord('sysapproval_approver)

gr.addQuery('document_id', current.sys_id);

gr.query();

if(gr.next())

approver= gr.approver.name;

[priyasunku]

@Snowman10 

please mark the answer as correct. so that it will be useful for others.