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]

Hi @Sharath807 ,

Sure, try the below:

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();

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

[Sharath807]

@SN_Learn  tried but the request is not updating.

[SN_Learn]

Please share your code and screenshots of RITM and REQ

[Sharath807]

@SN_Learn  screenshots shared

[SN_Learn]

Hi @Sharath807 ,

Thanks for sharing the code, looks correct:

Could you please check adding the below line and try again:

var ritmRec = new GlideRecord('sc_req_item');
//RITM sysID
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();

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