Hello @PRAGHATIESH S
To ensure a RITM only closes after all associated Catalog Tasks are closed:
Business Rule Configuration
- Table: sc_task
- When to run: After insert or update
- Condition: State is closed
Updated script in BR:
(function executeRule(current, previous /*null when async*/) {
var ritm = new GlideRecord('sc_req_item');
if (ritm.get(current.request_item)) {
var tasks = new GlideRecord('sc_task');
tasks.addQuery('request_item', ritm.sys_id);
tasks.addQuery('state', '!=', 'closed'); // Adjust 'closed' as per your states
tasks.query();
if (!tasks.hasNext()) {
ritm.state = 'closed'; // Adjust 'closed' as per RITM states
ritm.update();
}
}
})(current, previous);
This will trigger when the state in sc_task is closed, checks for the ritm and check all the task associated with this RITM is closed. Then only update the RITM state to closed.
Note: Adjust closed state as per your requirement.
"If you found my answer helpful, please like and mark it as an "accepted solution". It helps others find the solution more easily and supports the community!"
Thank You
Juhi Poddar
