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.

[Ankur Bawiskar]

@TMKAM 

you can use email script and include that in your notification of RITM table

(function runMailScript(current, template, email, email_action, event) {

    // Add your code here
    var arr = [];
    var approvalGR = new GlideRecord('sysapproval_approver');
    approvalGR.addQuery('sysapproval', current.sys_id);
    approvalGR.addQuery('state', 'requested');
    approvalGR.query();
    while (approvalGR.next()) {
        arr.push(approvalGR.approver.getDisplayValue());
    }
    template.print('Approvers for RITM are:' + arr.toString());


})(current, template, email, email_action, event);

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

[TMKAM]

Dear Ankur,

Thank you for the solution and I have tries but i cant show the approver anme and here are the mail scripts i have inserted in the email notification.

<mail_script>

// Add your code here
var arr = [];
var approvalGR = new GlideRecord('sysapproval_approver');
approvalGR.addQuery('sysapproval', current.sys_id);
approvalGR.addQuery('state', 'requested');
approvalGR.query();
while (approvalGR.next()) {
arr.push(approvalGR.approver.getDisplayValue());
}
template.print('Approvers for RITM are:' + arr.toString());

</mail_script>

[Ankur Bawiskar]

@TMKAM 

please share screenshots of where are you writing this?

is this in workflow notification activity?

are there approval records for this RITM in requested state?

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

[TMKAM]

Hi Ankur,

in the email notification... screeshot attached.

[Ankur Bawiskar]

@TMKAM 

you need to study how notifications work and how to include email script in it

once you create email script you need to include like this in Message HTML

${mail_script:mailScriptName}

Notification Email Scripts 

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