Display Multi row variable set columns in notification

Chenab Khanna · ‎09-04-2020

Hi

I have a multi row variable set and there is data in the columns. Does anyone have any idea how can i display that table in notification?

I am using email script wherein i am calling the variables via GlideAppVariablePoolQuestionSet, but unable to get the multi row variable?

Is there any way possible?

or may be some columns in it?

Ankur Bawiskar · ‎09-14-2020

@Chenab Khanna

that's correct.

If you are using any reference variable inside MRVS you will get sys_id and not the display value

you will have to query the reference table with that sys_id and get the display value.

Something like this

Updated in bold is the change

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
 /* Optional EmailOutbound */
 email, /* Optional GlideRecord */ email_action,
 /* Optional GlideRecord */
 event) {
 var req_id = current.sysapproval;
 template.print('' + req_id.number + '');
 template.print(' : ' + req_id.short_description + ' ');

 //print variables
 var set = new GlideappVariablePoolQuestionSet();
 set.setRequestID(req_id);
 set.load();
 var vs = set.getFlatQuestions();

 if (vs.size() > 0) {
 template.print('Request Item Variables: ');
 for (var i = 0; i < vs.size(); i++) {
 var show_line = 'true';
 if (vs.get(i).getLabel() == 'Line Manager Approval required?' || vs.get(i).getLabel() == 'Line Manager') {
 show_line = 'false';
 }

 if (vs.get(i).getLabel() == 'AD Action') {
 var ritmGR = new GlideRecord('sc_req_item');
 if (ritmGR.get(req_id)) {
 gs.log("Entered into the IF conditon of AD Action");

 template.print('<table>');
 template.print('<th>Name</th><th>Email</th><th>Department</th>');
 var mrvs = ritmGR.variables.ad_management_multirow; //check and put correct name
 var rowCount = mrvs.getRowCount();
 gs.log("print mrvs " + mrvs);
 gs.log("Row count of MRVS length " + rowCount);

 for (var s = 0; s < rowCount; s++) {
 var row = mvrs.getRow(s);

 var displayDepartmentValue = getActualValue('cmn_department', row.user_department);

 template.print("<tr>");
 template.print("<td><center>" + row.user_name + "</center></td>"); //check fieldname
 template.print("<td><left>" + row.user_email + "</left></td>"); //check fieldname
 template.print("<td><left>" + displayDepartmentValue + "</left></td>"); //check fieldname
 template.print("</tr>");
 }

 template.print('</table>');
 }
 }
 if (vs.get(i).getLabel() != '' && vs.get(i).getLabel() != null && show_line == 'true' && vs.get(i).getDisplayValue() != '' && vs.get(i).getLabel() != 'AD Action') {
 template.space(4);
 template.print('' + vs.get(i).getLabel() + ": " + vs.get(i).getDisplayValue() + " ");

 }
 }
 }

 function getActualValue(table, value){

 var gr = new GlideRecord(table);
 gr.addQuery("sys_id", value);
 gr.query();
 if (gr.next()) {
 return gr.getDisplayValue();
 }
 }

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