Generate multiple RITMs based on list collector variable

[danreesejr]

Hello,

Requirement is a new catalog item for a training request.  Requestor should have the ability to select multiple "requested for" users who will be participants in the requested training. Each of the participants may have different approval managers.  Submitting the request should generate a RITM for each user in the participants list with their name in the requested for of the RITM and all the variables cloned to each request.

Is this possible?

I have attempted the solution in the following thread:
To trigger multiple request items on a single request based on the list collector variable

My adjusted code in a runscript looks like this:

var listStr = current.variables.list_collector.toString(); // Assuming you have a variable called 'list_collector' change as appropriate
var list = listStr.split(',');
for (var i = 0; i < list.length; i++) {
    var ritm = new GlideRecord('sc_req_item');
    ritm.initialize(); // ritm.newRecord() seems to have the same result
    ritm.request = current.request;
    // populate other fields here
    ritm.requested_for = list[i];
    ritm.cat_item = current.cat_item;
    ritm.insert();
}

The code successfully creates a new RITM for the corresponding number of items in the list collector.  It correctly populates the values for the parent request and catalog item, but not the requested_for (it seems to default to the requested by value).

Also,it is not attaching or starting the item workflow to the newly created items:


Is this even possible to accomplish?

Thanks,

Dan

[Shane J]

Dan, I will post a likely lengthy reply on Monday AM.  I've been through this and I think I finally have worked all of the bugs out, but there's a bunch of different pieces.

[Stephen17]

Hi Shane;

 I have similar situation but i need to write the script in the script box on the order guide. So we have a list collector variable that is a reference to the cmdb_software_product_model table. The values showing in the List collector are also simialr values in the sc_cat_item table. so i.e. if you select IWD in the list collector, we want to add the IWD catalog item to the order guide when  it is check out. We can do this with rule based but we have a lot of software and customer can select a lot so we trying to avoid writing the rule for each. We considered the script to loop through what was selected in the list collector and add the item using this 

guide.add(“<sys_id_of_cat_item>")

we were unable to do the loop and were unable to grab the value of the variable. Do you have any suggestions?

[danreesejr]

Thank you so much!  Looking forward to seeing the pieces 🙂

[Shane J · Accepted solution]

Ok, so here (I think) is everything I had to do to  get this to work.

1. On the Request table, setup a List Collector referencing the User table (I called it:  Also Requested For).

2.  on the Request table, setup a checkbox field (I called it:  Copy Completed).

3.  on the Request table, create a before Business Rule with the following parameters:

Use the following script.  Take note of some of my notes in the script, as they directly address some of the issues you are seeing.

(function executeRule(current, previous /*null when async*/) {
	
	var copyList = current.u_also_requested_for;
	var copyArray = copyList.split(",").sort();
	var arrayUtil = new ArrayUtil();
	for (u = 0; u < copyArray.length; u++)
		{
		//this was using Incident to test validity of code
		//	var gr = new GlideRecord('incident');
		//gr.initialize();
		//gr.caller_id = copyArray[u]; //using the slice of the array [u]
		//gr.insert();
		
		//Create the extra Request for each person in 'Also Requested For'
		var gr = new GlideRecord('sc_request');
		gr.initialize();
		gr.requested_for = copyArray[u]; //using the slice of the array [u]
		gr.parent = current.sys_id;  //all copied have a Parent
		gr.opened_by = current.opened_by;
		gr.insert();
		gs.log("Also Request For Create Records BR run: " + current.number + ' ' + gr.number + ' requested for ' + gr.requested_for.getDisplayValue());
			
		//Find the Requested Item children of the current Request
		var items = new GlideRecord('sc_req_item');
		items.addQuery('request', current.sys_id);
		items.query();
		//Create Requested Item child for each found
		while (items.next()){
			var citems = new GlideRecord('sc_req_item');
			citems.initialize();
			citems.request = gr.sys_id;
			citems.requested_for = copyArray[u];
			citems.cat_item = items.cat_item;
			citems.insert();
			
			var TheItem = items.cat_item.toString();
			
			var tecvar = new GlideRecord('io_set_item');
			tecvar.addQuery('sc_cat_item',TheItem);
			tecvar.query();
			
			//Put catalog item "'Request other equipment'" variable sets list to array  OtherEquipmentVariableSetsList
			var OtherEquipmentVariableSetsList = [];
			while (tecvar.next())
				{
					OtherEquipmentVariableSetsList.push(tecvar.getValue('variable_set'));
						}
			
			//gs.log("lotg:" + "OtherEquipmentVariableSetsList =" + OtherEquipmentVariableSetsList);
			//Search for stored variables for current request
			
			var vgr = new GlideRecord('sc_item_option_mtom');
			vgr.addQuery('request_item',items.sys_id);
			vgr.query();
			while (vgr.next()){
				vgr.request_item = citems.sys_id;
				vgr.insert();
			}
			
			//Update the RITM to cause Start Workflow BR to trigger
			citems.description = '.';
			citems.update();
			
			
			
			
			
			/**
			//meant to copy the variables, modified from BR to copy variables from RITM to Catalog Task
			var questions = [];
			var catalogItem = items.cat_item.toString();
			var variableSets = [];
			
			var getVariableSets = new GlideRecord('io_set_item');
			getVariableSets.addQuery('sc_cat_item',catalogItem);
			getVariableSets.query();
			while(getVariableSets.next()) {
				variableSets.push(getVariableSets.getValue('variable_set'));
			}
			
			var getCatalogVariables = new GlideRecord('item_option_new'); getCatalogVariables.addQuery('cat_item='+catalogItem+'^active=true^NQvariable_set.sys_idIN'+variableSets.toString()+'^active=true');
			getCatalogVariables.query();
			while(getCatalogVariables.next()) {
				questions.push(getCatalogVariables.getValue('sys_id'));
			}
			
			var variablesCount = questions.length;
			var currentTaskID = items.sys_id.toString();
			
			//this part creates the variables
			for(var i=0;i<variablesCount;i++)
				{
				var getTaskVariables = new GlideRecord('sc_item_variables_task');
				getTaskVariables.addQuery('task',currentTaskID);
				getTaskVariables.addQuery('variable',questions[i]);
				getTaskVariables.setLimit(1);
				getTaskVariables.query();
				if(!getTaskVariables.hasNext())
					{
					getTaskVariables.initialize();
					getTaskVariables.setValue('task',currentTaskID);
					getTaskVariables.setValue('variable',questions[i]);
					getTaskVariables.insert();
				}
			}**/
			
			
			
			
		}
		
		
		
		
	}
	
	current.u_copy_completed = true;
	
})(current, previous);

4.  In my case I needed this for an Order Guide, so I created one specific to when people needed to request the same thing for multiple people.

5.  In that Order Guide, I needed a way to get the other users.  I did so via a Variable Set (in theory so I could use this anywhere).

6.  The Request workflow needed to be updated.  You may need to adjust this to your specific situation:

The Run Script:  Get Also Requested For, use this script:

var critm = new GlideRecord ('sc_req_item');
critm.addQuery('request', current.sys_id);
critm.orderByDesc('number');
critm.setLimit(1);
critm.query();
if (critm.next()){
	if (critm.variables.copy_user_list != ''){
	current.u_also_requested_for = critm.variables.copy_user_list;
	//current.update();
	}
}

 I think that's everything...  Getting this to work has taken a long time and a bunch of different updates as issues were found, but hopefully I didn't miss anything.