Display Multi row variable set columns in notification

[Chenab Khanna]

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]

@Chenab Khanna 

please share your sample MRVS json string and the script you are trying

Regards
Ankur

[Chenab Khanna]

Hi, please find the script below - 

(function runMailScript( /* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */
email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */
event) {
var req_id = current.sysapproval;
template.print('<p><span style="font-family: arial, helvetica, sans-serif; font-size: 10pt;"><strong>' + req_id.number + '</strong>');
template.print(' : ' + req_id.short_description + ' <br /> <br />');

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

if (vs.size() > 0) {
template.print('<strong>Request Item Variables:</strong><br /><br />');
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(current.sys_id)) {
gs.log("Entered into the IF conditon of AD Action");

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);
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>" + row.user_department + "</left></td>"); //check fieldname
template.print("</tr>");
}
}
}
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('<strong>' + vs.get(i).getLabel() + "</strong>: " + vs.get(i).getDisplayValue() + "<br />");

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

I have been trying different things, this time it did not go into the if condition - Entered into the IF conditon of AD Action

[Ankur Bawiskar]

@Chenab Khanna

please update code as below

use req_id to query

if (ritmGR.get(req_id)) {

Regards
Ankur

[Chenab Khanna]

Worked. Now i am able to get the values in the notification but its not coming in a tabular format. 

and also i am getting the sys id's. Can you help on this?

[asifnoor]

Hello Chenab,

add <tr border=1> in your notification, then you will see a tabular format.

Mark the comment as helpful if it helps.