I'll assume this isn't working, either at all, or not how you expect. I'll share a script I use that may help. In this scenario the List Collector variable is on the cmdb_ci table, so for each CI selected an RITM is created within the same REQ, and the same simple workflow is executed on each RITM. This also converts the original RITTM into only processing the first CI selected, and also works if only one CI is selected. This means you don't need an approval activity and path for each possible location in your scenario, unless there's something different that happens.
var cilist=[];
var ritmsysid = '';
//get sysids of variables that will be populated on new RITMs
var v_db_cat = '9f29df1bdbe48f004a29df6b5e9619c3';
var v_integration_status = 'bbfcbc9cdb298b00262950a45e961958';
//get multiple values, split into an array
var items = current.variables.v_db_cat.toString();
items = items.split(',');
//if only one item was selected, set the values per usual
if(items.length == 1){
var ci = new GlideRecord ('cmdb_ci');
ci.addQuery('sys_id', items[0]);
ci.query();
if(ci.next()){
current.short_description = current.cat_item.name + ' - ' + ci.name;
}
}
//or else set the values on the initial, existing RITM, and change the selected item to the first one
else{
current.variables.v_db_cat = items[0];
var ci = new GlideRecord ('cmdb_ci');
ci.addQuery('sys_id', items[0]);
ci.query();
if(ci.next()){
current.short_description = current.cat_item.name + ' - ' + ci.name;
}
//create a new RITM under the same REQ for all of the other selected values
for (var i = 1; i < items.length; i++) {
var ritm = new GlideRecord('sc_req_item');
ritm.initialize();
ritm.request = current.request;
ritm.cat_item = current.cat_item;
ritm.opened_by = current.opened_by;
var ci2 = new GlideRecord ('cmdb_ci');
ci2.addQuery('sys_id', items[i]);
ci2.query();
if(ci2.next()){
ritm.short_description = current.cat_item.name + ' - ' + ci2.name;
}
var sysID = ritm.insert();
//Add variables to the new RITMs
addVariable(sysID, v_integration_status, current.variables.v_integration_status,1);
addVariable(sysID, v_db_cat, items[i],2);
}
//Start the workflow on all the new RITMs
startWf(current.request);
}
function addVariable(ritm,varID,value,order) {
var variable = new GlideRecord('sc_item_option');
variable.initialize();
variable.item_option_new = varID;
variable.value = value;
variable.order = order;
var sysID = variable.insert();
var itemm2m = new GlideRecord('sc_item_option_mtom');
itemm2m.initialize();
itemm2m.request_item = ritm;
itemm2m.sc_item_option = sysID;
itemm2m.insert();
}
function startWf(request) {
var ritm = new GlideRecord('sc_req_item');
ritm.addQuery('request',request);
ritm.addQuery('sys_id','!=',current.sys_id);
ritm.addNullQuery('context');
ritm.query();
while (ritm.next()) {
ritm.setForceUpdate(true);
ritm.update();
}
}
