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 

Can you provide screenshot of your code snippet..??

Also check what the backend value of "closed complete" choice.

[Priya Rao]

Hi @Vishal Birajdar ,

The backend value of the state is 3.

(function executeRule(current, previous /*null when async*/ ) {
    var request = current.request;
    var grItem = new GlideRecord('sc_req_item');
    grItem.addEncodedQuery('request=' + request + '^state!=3');
    grItem.query();

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

        if (grReq.next()) {
            grReq.state = 3;
            grReq.update();
        }
    }
})(current, previous);

[Vishal Birajdar]

Hi @Priya Rao 

I have checked with the same code...!!

Its updating the as expected...!!

[piyushsain]

Hi,

You can do this by creating an after BR on RITM table with trigger as State Closed or Complete and check in the BR that if the RITMS attached to the REQ of the current RITM are completed.

[Priya Rao]

@piyushsain ,

Thanks for your response. Can you please elaborate?