How to take string values from multi-row variable set to populate the Watch List on an incident

patricklatella · ‎03-26-2020

Hi all,

this should be easy I would think, but something isn't working. I have a record producer with a mult-row variable set with one variable (single line text) for capturing email addresses to be added to the incident's Watch List when the record producer is submitted.

How do I access the values in the multi-row variable set to populate the Watch List? In the RP script i'm going with:

current.watch_list = producer.name_of_variable_in_variable_set; //variable in the variable set

Guessing there must be more to it?

thanks!

Brad Bowman · ‎03-31-2020

Hi Patrick,

I had some more time to fiddle with this and got it to work with the below. There's something about the record producer script vs an RITM workflow script that is making the shortcut not work somehow - even though the array seems to be created correctly.

var emailArr = [];
var mrvs = producer.bkbmrvstxt; //internal name of your MRVS
for(var i=0;i<mrvs.v_email.length;i++){ //name of the variable in the MRVS
 emailArr.push(mrvs.v_email[i]);
}
current.watch_list = emailArr.join(',');

View solution in original post

Ankur Bawiskar · ‎03-27-2020

Hi Patrick,

Can you print the value of mrvs? that would help knowing the json key

gs.info(producer.name_of_variable_in_variable_set);

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Brad Bowman · ‎03-30-2020

Here's a simple script I got to mostly work in a mock-up. Since this is a MRVS, pushing the variable values to an array is simplified.

var emailArr = [];
var mrvs = producer.bkbmrvstxt; //internal name of your MRVS
emailArr = mrvs.v_email; //name of the variable in the MRVS
current.watch_list = emailArr.join(',');

In my instance nothing gets assigned to the watchlist as emailArr.join(',') doesn't seem to be working for some reason. I confirmed through infoMessages that there are values in emailArr[0] and emailArr[1] when I add 2 rows that are valid email addresses of active Users, but then nothing is on the watchlist on the new incident and an infoMessage on emailArr.join(',') returns 'undefined', so that's as far as I got last week.

patricklatella · ‎03-30-2020

Hi Brad,

yep I'm getting the same "undefined" from the "emailArr.join". hmmmm...so odd?

Ankur Bawiskar · ‎03-30-2020

Hi Patrick,

Did you try to print the multi row variable set value in logs to check how the json looks like?

gs.info('MRVS is: ' + producer.variableName);

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

patricklatella · ‎03-31-2020

Hi Ankur, thanks for your help...Brad figured it out, check out his script.