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]

@Sharath807 ,

I have tested in PDI, please check the below:

Request:

Running the below in background script(RITM sysID is passed for reference):

var ritmRec = new GlideRecord('sc_req_item');
//RITM sysID
if (ritmRec.get('9f2965fc837fc210e1c15d10feaad38a')) {
    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();

        var reqUpdate = new GlideRecord('sc_request');
        if (reqUpdate.get(ritmRec.request)) {
            reqUpdate.setValue('approval', 'rejected'); //Set as per your requirement
            reqUpdate.update();
        }
    }
}

Result:

[Sharath807]

@SN_Learn  Its actually 'After'  'insert' business rule.  Is that a problem?

[SN_Learn]

Hi @Sharath807 ,

Please try with before insert + update.