Hi all,
Actually i have an issue with fetching the multi row variable set values in email notification which are reference variables while fetching it's populating sys_id in my code i have added getDispalyValue() then it's showing undefined so could you please any one guid me how to get that value. here am attaching my code and screen shots for your reference .
template.print('<table border="1px solid black">');
template.print( "<tr bgcolor='#ddd'align='center'>" );
template.print("<td style='text-align:center' colspan='10'><strong>Asset Allocation</strong></td>");
template.print( "</tr>" );
template.print( "<tr>" );
template.print( "<td><left><b>SAP_ASSETID </b></left></td>" );
template.print( "<td><left><b>ASSET_DESCRIPTION </b></left></td>" );
template.print( "<td><left><b>BOND_NO</b></left></td>" );
template.print( "<td><left><b>BOND_DATE</b></left></td>" );
template.print( "<td><left><b>COSTCENTER</b></left></td>" );
template.print( "<td><left><b>SERIAL_NO</b></left></td>" );
template.print( "<td><left><b>ASSETID</b></left></td>" );
// template.print( "<td><left><b>CITY</b></left></td>" );
// template.print( "<td><left><b>BUILDING</b></left></td>" );
// template.print( "<td><left><b>FLOOR</b></left></td>" );
// template.print( "<td><left><b>CUBICLE</b></left></td>" );
template.print( "</tr>" );
var mvrs = current.variables.asset_information;
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.sap_asset_number + "</left></td>" );
template.print( "<td><left>" +row.asset_description + "</left></td>" );
template.print( "<td><left>" +row.bond_number + "</left></td>" );
template.print( "<td><left>" +row.bond_date + "</left></td>" );
template.print( "<td><left>" +row.sap_cost_center_code + "</left></td>" );
template.print( "<td><left>" +row.serial_number + "</left></td>" );
template.print( "<td><left>" +row.asset_id + "</left></td>" );
template.print( "</tr>" );
}
template.print('</table>');
NOTE:-i have tried with row.sap_cost_center_code.getDispalyValue() then it's showing undefined for both fields
Advance thanks,
Regards,
sai bhargav p.
Hi thanks for your replay , i have tried this code in the email script, i want to get only for two reference fields get display values which are Asset_id, sap_cost_center_code
how can i glide only above Highlighted fields by using sc_multi_row_question_answer table
var gr = new GlideRecord("sc_multi_row_question_answer");
gr.addQuery("parent_id", current.sys_id);
gr.addQuery("variable_set", "asset_information");
gr.query();
if (gr.next()) {
gs.log(gr.value , "multirowCheck");
}
