Query in requested item

[servicenow lath]

In order guide( new Hire) .

All the Requested item is closed complete--> but the Request_State is not changing to closed complete.

[Ratnakar7]

hi @servicenow lath ,

You can follow below steps in flow designer:

1. Add a "Query Records" action to the flow and configure it to query for all Requested Items related to the specific Request.
2. Add a "Check Condition" action to the flow and configure it to check if all of the Requested Items in the result set have a State of Closed Complete.
3. If all of the Requested Items are Closed Complete, add an "Update Record" action to the flow and configure it to update the Request record's Request_State to Closed Complete.
4. Save and activate the flow.

If my response helps you to resolve the issue close the question by ✅Accepting solution and hit 👍thumb icon. From Correct answers others will get benefited in future.

Thanks,

Ratnakar

[Ratnakar7]

Hi @servicenow lath ,

Please try with below Business Rule Script:
Create new BR on sc_req_item table , like below:

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

var reqItemGr =new GlideRecord('sc_req_item');
reqItemGr.addEncodedQuery("state!=3^request="+reqItemGr.request); //check for all other  RITM status
reqItemGr.query();
if(reqItemGr.getRowCount()==0){ //If all RITM closed
	var reqGr =new GlideRecord('sc_request');
	reqGr.get(reqItemGr.request);
	if(reqGr.request_state!="closed_complete"){
		reqGr.setValue('request_state',"closed_complete"); //update Req to close
		reqGr.update();
	}
}

})(current, previous);

Thanks,

Ratnakar

[Ratnakar7]

Hi @servicenow lath ,

Alternatively you can Add an update action with Flow Designer and set the RITM stage to Completed. This will trigger business rules to close the RITM and the Request.

Please refer below KB articles:

How to close a RITM when the SC task is completed in Flow designer 

Request is not closing when all RITM & SCTASK tickets under it are closed 

If my response helps you to resolve the issue close the question by ✅Accepting solution and hit 👍thumb icon. From Correct answers others will get benefited in future.

Thanks,

Ratnakar

[servicenow lath]

@Ratnakar7 As Per Your suggestions i have created a Flow designer and BUsinees rule. 

But in the Sc_request Record the Request_state value is not changing to closed_complete. 

how to  solve this issue??