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.

[RohitGeorgV]

@TMKAM 

instead of var approverName = approverGR.approver.name; can you try 

//var approverName = approverGR.approver.getDisplayValue();