How to populate Request For name in Email notification

[shaik_irfan]

Hello Everyone,

i want to populate Requested By name under Email template, Requested For (u_req_for) is from RITM table which should be populated on Template i tried Select Variables which is present in the Template but i unable to find the Requested For name since the email template is written on Approval table.

Can anyone please help me out how to populate the RITM table field on Approval table ?

[younes_sebti]

You have to configure a mail script to query the requested item table. Not much of a choise

Then use the template.print function to print it

<mail_script>

var ritm = new GlideRecord('sc_req_item');

if(ritm.get(current.sysapproval)){

var req_for = ritm.u_req_for.name;

template.print("Requested for :"+req_for);

}

</mail_script>

Of course you don't need this trick for fields that are on the task table.

These can be accessed directly like for example the opened by ${sysapproval.opened_by}

I didn't test this code but I'm 100% certain that it will work

[shaik_irfan]

Younes,

there is already a mail script running for this template but i am not very sure where to add as i am new to scripting i an totally blank

[Rajesh Mushke]

Hi Irfan,

just add below line in HTML Message :

Request Requested for: ${request.requested_for}

[younes_sebti]

Yes this will work if Shaik wants to use the sc_request requested for.