question Re: Show MultiRow variable set in approval email notification in Developer forum

Show MultiRow variable set in approval email notification

NIcollas Viggia — Thu, 01 Sep 2022 12:23:08 GMT

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

Re: Show MultiRow variable set in approval email notification

Mohith Devatte — Thu, 01 Sep 2022 12:31:19 GMT

hello @NIcollas Viggiano ,

try this script once

Also make sure your syntax of accessing email script in notification is like below

${mail_script:your_mail_script_name}

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

        var obj = JSON.parse(current.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);

		}
	
}

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

Hope this helps

please mark my answer correct if this helps you

Re: Show MultiRow variable set in approval email notification

MrMuhammad — Thu, 01 Sep 2022 12:38:01 GMT

@NIcollas Viggiano - Please try this:

(function runMailScript(/* GlideRecord */ current, /* TemplatePrinter */ template,
   
        var mrvs = record.variables.request_information; //update with your variable set name
        var objectCount = obj.getRowCount();
	for(var i=0; i< objectCount .length; i++) {
        var row = mrvs.getRow(i)
	template.print('<br/>' + 'System: ' + row.system_name); 
	template.print('<br/>' + 'Profile: ' + row.profile_name);
	template.print('<br/>' + 'Approver: ' + row.aprovador_do_perfil);
// you copy and paste the template.print line and add more variables here	
		}
	}
}

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

Re: Show MultiRow variable set in approval email notification

NIcollas Viggia — Thu, 01 Sep 2022 13:53:28 GMT

I tried this, but still not showing the variables from multirow.

I check the syntax in notification, and its correct.

Re: Show MultiRow variable set in approval email notification

NIcollas Viggia — Thu, 01 Sep 2022 13:54:02 GMT

still not working with that

Re: Show MultiRow variable set in approval email notification

MrMuhammad — Thu, 01 Sep 2022 14:01:42 GMT

@NIcollas Viggiano - Can try gs.info(mrvs) and let me know what it logs?

Also, please see this article for reference as well.
How to Display Multi Row Variable set (MRVS) data in a notification | Article

Re: Show MultiRow variable set in approval email notification

MrMuhammad — Thu, 01 Sep 2022 14:07:11 GMT

@NIcollas Viggiano - Ah just realized there was a typo in my script. Please try below

(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()) {
        var mrvs = current.variables.request_information; //update with your variable set name
        var objectCount = obj.getRowCount();
	for(var i=0; i< objectCount .length; i++) {
        var row = mrvs.getRow(i)
	template.print('<br/>' + 'System: ' + row.system_name); 
	template.print('<br/>' + 'Profile: ' + row.profile_name);
	template.print('<br/>' + 'Approver: ' + row.aprovador_do_perfil);
		}
	}
}

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

Re: Show MultiRow variable set in approval email notification

Ankur Bawiskar — Thu, 01 Sep 2022 15:25:17 GMT

Hi,

update as this -> your notification and email script is on sysapproval_approver

(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.sysapproval;
record.addQuery('sys_id', sysCurrentRecordSysId);
record.query();
if (record.next()) {
var obj = JSON.parse(record.variables.request_information); //update with your variable set name
for(var i=0; i<obj.length; i++) {
template.print(' ' + 'System: ' + obj[i].system_name);
template.print(' ' + 'Profile: ' + obj[i].profile_name);
template.print(' ' + 'Approver: ' + obj[i].aprovador_do_perfil);
}
}
}

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

Regards
Ankur

Re: Show MultiRow variable set in approval email notification

NIcollas Viggia — Thu, 01 Sep 2022 18:55:21 GMT

Hi Ankur, Thanks for this solution,

Its working but for "system_name" and "profile_name" is returning the Sys_ID, any idea how can i get the name for this variables?

Re: Show MultiRow variable set in approval email notification

Ankur Bawiskar — Fri, 02 Sep 2022 04:47:15 GMT

@NIcollas Viggiano

Glad to know.

For that sysId you need to query the table being referred by that variable and then get the display value

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

var rec = new GlideRecord('tableReferredBySystemName');
rec.get(obj[i].system_name);

var rec1 = new GlideRecord('tableReferredByProfileName');
rec1.get(obj[i].profile_name);

template.print(' ' + 'System: ' + rec.getDisplayValue());
template.print(' ' + 'Profile: ' + rec1.getDisplayValue());
template.print(' ' + 'Approver: ' + obj[i].aprovador_do_perfil);
}
}
}

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

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur

Re: Show MultiRow variable set in approval email notification

NIcollas Viggia — Fri, 02 Sep 2022 11:18:51 GMT

Thanks Ankur, now its working perfectly.

Re: Show MultiRow variable set in approval email notification

Insider — Thu, 20 Jul 2023 12:33:00 GMT

Hello Ankur,

Hope your doing well.
I am trying to print both variable and multiple row variable set data on the approver email notification.
can you help me with this?

Re: Show MultiRow variable set in approval email notification

Ankur Bawiskar — Thu, 20 Jul 2023 13:58:44 GMT

@Insider

Could you raise a new thread for this and tag me there?

Re: Show MultiRow variable set in approval email notification

Insider — Thu, 20 Jul 2023 15:11:06 GMT

Yes Ankur, i did
https://www.servicenow.com/community/developer-forum/display-variable-and-multiple-row-variable-sets-data-into/m-p/2619133/thread-id/1018416

Re: Show MultiRow variable set in approval email notification

Insider — Thu, 20 Jul 2023 16:02:16 GMT

Sure,

https://www.servicenow.com/community/developer-forum/display-variable-and-multiple-row-variable-sets-data-into/m-p/2619133/thread-id/1018416

Re: Show MultiRow variable set in approval email notification

sowmya28 — Mon, 28 Aug 2023 17:48:26 GMT

@Ankur Bawiskar

My variable in variable set is of type List collector. Can you please help me how can I display multiple values.

Re: Show MultiRow variable set in approval email notification

Ankur Bawiskar — Tue, 29 Aug 2023 03:28:32 GMT

@sowmya28

Can you post a new question as this is an older one and tag me there?