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

Harsh Vardhan · ‎10-16-2019

can you add the screenshot please. backed name would be always in small .

kun1 · ‎10-16-2019

Harsh Vardhan · ‎10-16-2019

try now

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

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

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

kun1 · ‎10-16-2019

It same you pinged below!!

I tried but nothing happen

Harsh Vardhan · ‎10-16-2019

my bad now i noticed , you have to do glide-record here on the reference variable table

try now.

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

var typ = current.variables.property_authorization_card.Type;

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

gr.addQuery('sys_id',typ);

gr.query();

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

if(gr.next()){

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

}

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