Hi
In that case you need to follow the steps below and then do it:
1) First create a hidden field on Requested Item Table say name it as "Check Reopen" and type of the field will be as "True/False" as shown below:
2) Now create a Before Update business Rule as per details shared below:
BR Details:
Table Name : Requested Item
When: Before Update
Condition: State Changes to Reopen and Check Reopen is False
Script:
This BR will set the value of the hidden field to True only once when any of the RITM is moved to Reopen. So using this you can identify for which RITM the catalog task need to be created and also it will be created just once.
Now the next step is to write another BR on Requested Item table and use the details as shared below:
BR Details:
Table Name: Requested Item
When: After Update
Order : 1000
Condition: Check Reopen Changes to True AND State is Reopen
Script:
(function executeRule(current, previous /*null when async*/) {
// Add your code here
var getRequest = current.request;
var gr = new GlideRecord('sc_request');
gr.addQuery('sys_id',getRequest);
gr.query();
if(gr.next()){
var getRITM = getAllRITM(gr.sys_id,current,gr);
}
function getAllRITM(reqID,current,gr){
var gr1 = new GlideRecord('sc_req_item');
gr1.addQuery('request',reqID);
gr1.addQuery('u_check_reopen',true);
gr1.query();
if(!gr1.next()){
createCatalogTask(current,gr1);
}
}
function createCatalogTask(current,gr1,gr){
var gr2 = new GlideRecord('sc_task');
gr2.initialize();
gr2.request_item = gr1.sys_id;
gr2.parent= gr1.sys_id;
gr2.FIELD_NAME = gr1.Field_Name; // Replace "FIELD_NAME" with field of Catalog Task and "Field_Name" with the field of Requested Item table which you want to copy
gr2.insert();
}
})(current, previous);
Hope this helps. Please mark the answer as correct/helpful based on impact.
Regards,
Shloke
