Hi, i am trying to retrieve variables from a Multirow variable set to an approval notification (sysapproval_approver table), but i am have trouble with that, i tried some solutions that i have seen in the forum, but that doesn't work for me. Below the email script that i am trying to use.
(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
/* Optional EmailOutbound */ email, /* Optional GlideRecord */ email_action,
/* Optional GlideRecord */ event) {
var record = new GlideRecord('sc_req_item');
var sysCurrentRecordSysId = current.sys_id;
record.addQuery('sys_id', sysCurrentRecordSysId);
record.query();
while (record.next()) {
//Note, the value is a JSON string, so we parse it back into an obect to make it easier to work with
var obj = JSON.parse(record.variables.request_information); //update with your variable set name
for(var i=0; i<obj.length; i++) {
template.print('<br/>' + 'System: ' + obj[i].system_name);
template.print('<br/>' + 'Profile: ' + obj[i].profile_name);
template.print('<br/>' + 'Approver: ' + obj[i].aprovador_do_perfil);
// you copy and paste the template.print line and add more variables here
}
}
}
)(current, template, email, email_action, event);Below what is showing in the notification, its only retrieve the catalog variables and not the multirow that i setup in the mail script
1 ACCEPTED SOLUTION
