Update REQ based on RITM state and stage

[Priya Rao]

Hi all,

I have created an order guide, and it contains four different catalog items, each of which follows a different flow. I have used flow design. Now, I want to check the status of each RITM, and if the state and stage of all four RITMs are complete, then I need to update the REQ record for those RITMs. How can I achieve this?

Thanks in advance!

@Ankur Bawiskar @Rahul Talreja @Pavankumar_1 @Samaksh Wani @Vishal Birajdar @Dr Atul G- LNG @Hemanth M1 @Saurabh Gupta @Sagar Pagar @Aman Kumar S 

[Vishal Birajdar · Accepted solution]

Hi @Priya Rao 

Ok so yo need write Business rule as below on RITM table :

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

    /* 1. Get the request from current form */
    var request = current.request;

    /* 2. Glide Record on Request item table & check if there is any RITM which is not in closed complete state */
    var grItem = new GlideRecord('sc_req_item');
    grItem.addEncodedQuery('request=' + request + '^state!=3');
    grItem.query();

    if(!grItem.next()){
		/* update request record */
		var grReq = new GlideRecord('sc_request');
		grReq.addQuery('sys_id',request);
		grReq.query();

		if(grReq.next()){
              // set values on request
			  grReq.state = 3;
			  grReq.update();
		}

	}

})(current, previous);

Hope this helps....!!

[piyushsain · Accepted solution]

var request = current.request;
var grRITM = new GlideRecord('sc_req_item');
grRITM.addEncodedQuery('stateNOT IN3,4,7^request=' + request);
grRITM.query();
    if (!grRITM.hasNext()) {
        var req = new GlideRecord('sc_request');
        req.get(request);
        req.state = ''; //Update according to your requirement
    }

[Vishal Birajdar]

Hi @Priya Rao 

As its order guide , then there will be only one Request will be created for all four RITMS.

May be can you provide some screenshot for more clarity.

[Priya Rao]

Hi @Vishal Birajdar ,

Based on the state of these 4 RITM's, (I'll be closed complete) I need to update the state of the REQ to Complete.

[Vishal Birajdar · Accepted solution]

Hi @Priya Rao 

Ok so yo need write Business rule as below on RITM table :

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

    /* 1. Get the request from current form */
    var request = current.request;

    /* 2. Glide Record on Request item table & check if there is any RITM which is not in closed complete state */
    var grItem = new GlideRecord('sc_req_item');
    grItem.addEncodedQuery('request=' + request + '^state!=3');
    grItem.query();

    if(!grItem.next()){
		/* update request record */
		var grReq = new GlideRecord('sc_request');
		grReq.addQuery('sys_id',request);
		grReq.query();

		if(grReq.next()){
              // set values on request
			  grReq.state = 3;
			  grReq.update();
		}

	}

})(current, previous);

Hope this helps....!!

[Priya Rao]

@Vishal Birajdar , Thanks for your response. I tried with this but it's not setting the state of the REQ to Closed Complete when all the RITM's are closed.