Close REQUEST when RITM is closed

[Gurpreet Kaur5]

Good afternoon, 

I have created a flow where when the SC is closed, it will close the RITM.

However i am struggling to add the steps where - After the RITM is closed, it should close the REQ 

When i am trying to add the Action, i do not see REQ in the Data pill to choose-

Please advise how can i add the REQ to close please.

One of my colleague said it should automatically close REQ, which is not happening either, hence working on the flow 

[Dr Atul G- LNG]

Hi @Gurpreet Kaur5 

Greetings!!

Could you please check the OOTB Flow , may be you need to set the stages as well. 

https://INSTANCENAME.service-now.com/$flow-designer.do?sysparm_nostack=true#/flow-designer/30f3d2618...

[Gurpreet Kaur5]

Hi Atul, 

I couldn't manage to open the page. I changed the instance name too, but no good. 

I checked there's an OOB BR which was enabled but it did not close the REQ as needed. 

I created a BR using this (which i saw in another post ) - 

(function executeRule(current, previous /*null when async*/ ) {

    var grReq = new GlideRecord('sc_request');

    grReq.addQuery('sys_id', current.request);//get the request from RITM

    grReq.query();

    if (grReq.next()) {

        grReq.request_state = 'closed_complete'; //add your field  name

        grReq.update();

    }

})(current, previous);

It worked for me. 

[Danish Bhairag2]

Hi @Gurpreet Kaur5 ,

you can instead create a BR on RITM table n trigger when state is changed to closed complete. In advanced section u can write this script 

var gr = new GlideRecord('sc_request');
gr.addQuery('sys_id',current.request);
gr.query();
if(gr.next()){
gr.state = 'closed_complete'; // update backedn value of closed complete
gr,update();
}

Thanks,

Danish

[Gurpreet Kaur5 · Accepted solution]

Hi Danish, 

I created a new BR using  this script - 

(function executeRule(current, previous /*null when async*/ ) {

    var grReq = new GlideRecord('sc_request');

    grReq.addQuery('sys_id', current.request);//get the request from RITM

    grReq.query();

    if (grReq.next()) {

        grReq.request_state = 'closed_complete'; //add your field  name

        grReq.update();

    }

})(current, previous);

I tested it and managed to close the REQ.

Hope it wont conflict with other BRs