question need to close RITM after all sc_tasks are completed in CSM forum

need to close RITM after all sc_tasks are completed

Vani14 — Mon, 24 Apr 2023 05:48:00 GMT

For one RITM, we built two sc_tasks. When I try to close one sc_task, RITM closes but another sc_task remains open. Can somebody assist me in closing all sc_tasks before RITM closes?

Re: need to close RITM after all sc_tasks are completed

Rahul Kumar17 — Mon, 24 Apr 2023 05:57:57 GMT

By creating a Business Rule on the sc_task table that triggers when a task is closed. In the Business Rule, you can check if all the related sc_tasks are closed, and if so, you can close the associated RITM.

Here is an example of a Business Rule script that you can use as a starting point:

// Get the current sc_task and its associated RITM var currentTask = current; var currentRITM = currentTask.request_item; // Get all the sc_tasks associated with the RITM var taskGr = new GlideRecord('sc_task'); taskGr.addQuery('request_item', currentRITM); taskGr.query(); // Check if all the sc_tasks are closed var allTasksClosed = true; while (taskGr.next()) { if (taskGr.getValue('state') != '7') { // '7' is the state value for Closed allTasksClosed = false; break; } } // If all sc_tasks are closed, close the associated RITM if (allTasksClosed) { currentRITM.setValue('state', 3); // '3' is the state value for Closed Complete currentRITM.update(); }

Thanks,

Rahul Kumar

Re: need to close RITM after all sc_tasks are completed

Ankur Bawiskar — Mon, 24 Apr 2023 06:04:50 GMT

@Vani14

you can use after update BR on sc_task with proper conditions for State value

Condition: State [IS ONE OF] Closed complete, Closed incomplete, Closed skipped

Script:

(function executeRule(current, previous /*null when async*/) { // Add your code here // check if there is no active task for this RITM var gr = new GlideRecord("sc_task"); gr.addActiveQuery(); gr.addQuery("request_item", current.request_item); gr.setLimit(1); gr.query(); if (!gr.hasNext()) { var ritm = current.request_item.getRefRecord(); ritm.state = 3; ritm.update(); } })(current, previous);

you can also use Flow designer with no script for this

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: need to close RITM after all sc_tasks are completed

Vani14 — Mon, 24 Apr 2023 07:51:53 GMT

we are using this script is it correct.

(function executeRule(current, previous /*null when async*/) {

var gr=new GlideRecord('sc_task');
gr.addQuery('request_item',current.request_item);
gr.addQuery('state', '!=',current.state);//checking if all tasks are closed
if(!gr.next())

{
var grr = new GlideRecord('sc_req_item');
grr.get(current.request_item);

grr.state=current.state;

grr.update();
}
})(current, previous);

Re: need to close RITM after all sc_tasks are completed

Ankur Bawiskar — Mon, 24 Apr 2023 07:54:31 GMT

@Vani14

please use script I shared above.

sharing again with some changes

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: need to close RITM after all sc_tasks are completed

Vani14 — Mon, 24 Apr 2023 08:05:33 GMT

Hi @Ankur Bawiskar ,
its not working when i close one task its automatically closing RITM, another task is in open state.

Re: need to close RITM after all sc_tasks are completed

Ankur Bawiskar — Mon, 24 Apr 2023 08:49:55 GMT

@Vani14

share your BR configuration screenshot and latest script

Re: need to close RITM after all sc_tasks are completed

Vani14 — Mon, 24 Apr 2023 09:31:20 GMT

i did a mistake script is working thank you.