Hi Jleong
Please go through this, It will give you some clarity
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();
}
}
Please mark my comment helpful and correct.
Saurabh
