Add Approver History to notification

[achen]

Hello,

I am attempting to pull the approval history from a ritm and add it to a notification.  I have added this email script 

var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('sysapproval', current.sys_id);

gr.addQuery('state',approved);gr.query();

while(gr.next()){
template.print('Details');
}

but it pulls all approvers from the approval table and not the approvals for the current ritm.

Thank you,

Alex

[achen]

I have also attempted to add this script as well.

var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('sysapproval', current.sys_id);

gr.addQuery('state',approved);gr.query();

while(gr.next()){
template.print('Details');
}

[Aman Kumar S]

I think your query for approved is incorrect, shouldn't it be

gr.addQuery('state','approved')// quotes are missing

[Aman Kumar S · Accepted solution]

Hey,

I think your query for approved is incorrect, shouldn't it be

gr.addQuery('state','approved')// quotes are missing

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂

[achen]

Hello,

After adding the quotes to approved the email notification is now showing, "DetailsDetailsDetailsDetails".

Before when using that script it was blank but it is still not pulling in the approval history.

Alex