Pulling a field from approval table to requested item table into a Notification email

[TMKAM]

Hi All,

I want the approver name from this Approval (sysapproval_approver) table into the current notification Requested Item (sc_req_item) table.

How do I scripted that.

Regards,

TMKam

[Ankur Bawiskar · Accepted solution]

@TMKAM 

it should work if there are approval records in Requested state in sysapproval_approver table for your RITM

Did you verify that?

You can comment line 7 and see what it prints.

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

[Nishant8]

Hello @TMKAM, you can get the approver details using below script:

var approverName = '';
var approvalGR = new GlideRecord('sysapproval_approver');
approvalGR.addQuery('sysapproval', current.sys_id);
approvalGR.addQuery('state', 'requested'); // optional if looking for only requested items
approvalGR.query();
while(approvalGR.next()){
   approverName = approvalGR.approver.getDisplayValue());
}

Regards,

Nishant

[TMKAM]

Dear Nishant,

Thank you for the solution and I tried as per below but no reault was shown the in the email notification.

<mail_script>
var approverName = '';
var approvalGR = new GlideRecord('sysapproval_approver');
approvalGR.addQuery('sysapproval', current.sys_id);
approvalGR.addQuery('state', 'requested'); // optional if looking for only requested items
approvalGR.query();
while(approvalGR.next()){
approverName = approvalGR.approver.getDisplayValue());
template.print('Responsible ITC / DVK: '+ approverName +'<br />');
}
</mail_script>

[Nishant8]

Hello @TMKAM,  Include this code in email script and use in notification, and I believe it should work fine. please verify.

Regards,

Nishant

[TMKAM]

hi Nishant,

How to do I that as im pretty new to these scripting.

Thank you