Sys id displayed instead of Name in email notification

kun1 · ‎10-16-2019

Mail script:-

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

template.print(current.variables.property_authorization_card.Type+ '\n\n'+"<br/> Property card Details");

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

here issue is it provide me the sys id of Type. How to populate name instead of sys id.

Harsh Vardhan · ‎10-16-2019

search on google , you will find plenty of reference regarding the style .

try with below code.

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

var arr =[];

var variableArray = JSON.parse(current.variables.property_authorization_card);

for(var i=0; i < variableArray.length; i++) {

var gr = new GlideRecord('table name');

gr.addQuery('sys_id','IN',variableArray[i].Type);

gr.query();

gs.log('Row count'+ gr.getRowCount());

while(gr.next()){

arr.push(gr.name);

}

template.print(arr+ '\n\n'+"<br/> Property card Details");

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

View solution in original post

Sajilal · ‎10-16-2019

Try getDisplayValue()

Please mark the answer as Correct and Helpful, if it works for you.

Regards,
Sajilal

Harsh Vardhan · ‎10-17-2019

any updated on this thread.

if i answered your query, can you mark my answer as correct and close this thread.