MRVS Notification Email Script - Reference variables are not displaying values

matt_ellis · ‎07-09-2020

Hello!

I was looking for some help with figuring out the lines needed in an email script to display the value of a reference variable in a multi row variable set. The two variables in question are 'select_district' and 'building'.

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {

template.print('<table border="0px solid black">');
template.print( "<tr bgcolor='#ddd'align='center'>" );
template.print("<td style='text-align:center' colspan='10'>M/A/C Details</td>");
template.print( "</tr>" );

template.print( "<tr>" );
template.print( "<td><left>District</left></td>" );
template.print( "<td><left>Building</left></td>" );
template.print( "<td><left>Room #</left></td>" );
template.print( "<td><left>Employee Name</left></td>" );
template.print( "<td><left>Current Ext.</left></td>" );
template.print( "<td><left>New Ext.</left></td>" );
template.print( "<td><left>IP Phone?</left></td>" );
template.print( "<td><left>TN-Terminal Number or MAC</left></td>" );
template.print( "<td><left>Voicemail?</left></td>" );
template.print( "<td><left>Model</left></td>" );
template.print( "<td><left>Comments</left></td>" );
template.print( "</tr>" );

var mvrs = current.variables.nortel_avaya;
var ritm = current.getUniqueValue();
var rowCount = mvrs.getRowCount();
for (var i = 0; i < rowCount; i++) {
var row = mvrs.getRow(i);
template.print( "<tr>" );
template.print( "<td><left>" +row.select_district.getDisplayValue() + "</left></td>" );
template.print( "<td><left>" +row.building + "</left></td>" );
template.print( "<td><left>" +row.room + "</left></td>" );
template.print( "<td><left>" +row.employee_name + "</left></td>" );
template.print( "<td><left>" +row.current_ext + "</left></td>" );
template.print( "<td><left>" +row.new_ext + "</left></td>" );
template.print( "<td><left>" +row.ip_phone + "</left></td>" );
template.print( "<td><left>" +row.tn_terminal_number + "</left></td>" );
template.print( "<td><left>" +row.voicemail + "</left></td>" );
template.print( "<td><left>" +row.model + "</left></td>" );
template.print( "<td><left>" +row.comments + "</left></td>" );
template.print( "</tr>" );
}
template.print('</table>');

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

When .getDisplayValue is added, it returns as undefined. When left as 'building' is, it returns the sys ID instead of the reference value. Any help with this would be greatly appreciated.

Ankur Bawiskar · ‎07-09-2020

Hi,

you cannot use getDisplayValue() here

you need to query those 2 tables with that sys_id and get the display value and then print

var gr = new GlideRecord('district table'); // give proper table name here

gr.addQuery('sys_id', row.select_district);

gr.query();

if(gr.next()){

template.print( "<td><left>" +gr.name + "</left></td>" ); // give here the field on district table which stores name

}

var gr = new GlideRecord('building_table'); // give proper table name here

gr.addQuery('sys_id', row.building);

gr.query();

if(gr.next()){

template.print( "<td><left>" +gr.name+ "</left></td>" ); // give here the field on building table which stores name

}

Mark as Correct Answer & Helpful if this solves your issue or Helpful if this is useful to you.
Regards
Anukr

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Joe DeStefano2 · ‎11-17-2021

Worked like a charm!!