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
