ragz,
Do a query on the [io_set_item] table to find your catalog Item(s) with the particular variable set (in your case a MR var set) and put the display value of that sys_id into a variable:
**current record originates from the [sysapproval_approver] table**
//Depending on where you're running this script, you may have to replace 'current'
var targetRec = current.sysapproval;
var set = [];
var getSets = new GlideRecord("io_set_item");
getSets.addEncodedQuery(
"variable_set.type=one_to_many^sc_cat_item=" + targetRec.cat_item.toString()
);
getSets.setLimit(1); //you only need one record to return with the MRVS value
getSets.query();
if (getSets.next()) {
set.push(getSets.variable_set.internal_name.toString());
}
//now 'set' holds the internal name of your MRVS
var intName = set[0];
//with the internal name, you can use the variables object to get mrvs values
var mrvsString = targetRec.variables[intName];
the last line from the script above will return a JSON object, something like this:
Yeah, the names of the variables are nonsense but this is how the object is constructed.
Get each value with this syntax: gs.info(mrvsString[0]['SAR_first_name']);
To make this object a String value use : var something = JSON.parse(mrvsString);
Hope this helped!
