RITM should get close once all catalog tasks are closed

[tulasi8]

Hi Community,

I want the RITM should get close only once all the catalog tasks are closed. I have written the business rule for this after update with the condition as state is closed complete.  But it's not working as per requirement. Can anyone please help on this. 

    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 = current.state;

        ritm.update();

    }

Thanks,

Tulasi.

[Badrinarayan]

Look Up Catalog tasks , where request item is ritm , for each , Wait for conditions to close the sctasks , once look up count is 0 , then update the ritm 

[tulasi8]

It's not working for me even after updating the script. Can you please say what needs to be changed. @Badrinarayan 

Thanks,

Tulasi

[Badrinarayan]

Run the flow as System User , Use wait for condition in between to wait till the Catalog tasks are closed or not

Mark as helpful if your issue is resolved

Thanks regards

Badrinarayan

[Ashish Parab]

I will suggest you to utilize your existing flow which you have created for the catalog item.  Use Lookup Records action as below,

Then use if  -> Lookup Records count is greater than 0 then Update the Request and RITM to closed complete. ( in above lookup records action we are just checking how many closed incomplete or skipped catalog task for our RITM. If count is greater than 0 means there is no any closed incomplete/ skipped task so we are Closed Complete Request and RITM ) 

Please mark this response as Correct and Helpful if it assists you.

Thanks,
Ashish

[tulasi8]

@Ashish Parab can you please say where exactly i should give these actions ?