Auto Close RITM

[Sharath807]

Hello, I have requirement in which is an RITM is created for a catalog item without records in particular tab in related list then that RITM state should be auto changed to 'Closed cancelled'.. Is there any way to achieve this .Thanks in advance any help is appreciated.

[SN_Learn · Accepted solution]

Hi @Sharath807 ,

You can try the below in after insert business rule:

var ritmRec = new GlideRecord('sc_req_item');
if (ritmRec.get(current.sys_id)) {
    var checkReList = new GlideRecord('sc_task'); //Change with your table
    checkReList.addQuery('request_item', ritmRec.sys_id); //update the field name here as per your table
	checkReList.query();
	if(!checkReList.next()){
		ritmRec.setValue('stage', 'Request Cancelled');
		ritmRec.setValue('state', 4);
		ritmRec.update();
	}
}

[Sharath807]

HI @SN_Learn  can the related Request also be auto closed?

[SN_Learn]

Yes, you need to write business rule on sc_request table and write the similar script.

[Sharath807]

Hi @SN_Learn  when the RITM is auto cancelled , its related request should also be autocancelled. can it be achieved within  the same script in RITM?