RITM and REQ not closing after child tasks are closed.

[Jeremy F_]

Looking for some assistance figuring out why this workflow is not closing the RITM and the REQ after the SCTASKs have been completed. I've tried several workflow variations, but I can't get it figured out. There up to 4 separate tasks that are created depending on the selections made on the catalog item. There could 1, 2, 3, or 4 tasks created. I need all opened tasks to be completed before the RITM and REQ close. Currently, closing all tasks still leaves the RITM and REQ open.

[Sohail Khilji]

Why have you not made use of wait for condition activity to wait for all task to get completed?

[Jeremy F_]

I tried using the the wait for condition activity, but I must not be putting it in the right place. I'm new to creating workflows, so everything I've been doing has been trial and erro.

[Sohail Khilji]

Try to connect all your 4 task to wait for condition then set req value to close.

Kindly  mark the answer correct or helpful if it addresses your concern

[Gaurav Shirsat · Accepted solution]

Hello 

After Your Join Query Please add a Run Script Core Activity. and Add this script into that Run Script. also connect that set values activity which is at left side to this run script.

so after your set values(attached to join) and set values coming from left side, attach both these set values to this run script before end activity.

Please make some change if required as per requirement. but this is working code from my project.

var req= current.request.getRefRecord();

var gr= new GlideRecord('sc_task');

gr.addQuery('request_item',current.sys_id);

gr.addQuery('state','3');//get the list of all closed tasks

gr.query();

if(gr.getRowCount()>0){ //at least one closed task found

current.state='4'; //set the RITM state to closed
current.stage='complete';
req.stage = 'closed_complete';
req.state='3';

}else{
current.state='5';
current.stage='Request Cancelled';
req.stage = 'closed_incomplete';
req.state='3';

}
//current.update();
req.update();

Please Mark Correct and Helpful
Thanks and Regards
Gaurav Shirsat