I want to close all child incidents before closing parent incident, if any one child incident not closed the parent incident should not be closed

[Vijay8]

I want to close all child incidents before closing parent incident, if any one child incident not closed the parent incident should not be closed should populate a error message

I tried the code below but, If I try to close one child Incident parent incident is also getting closed 

I tried many solutions in community but, none of them work please help me with this

var inc = new GlideRecord('incident');
inc.addQuery('parent_incident', current.sys_id);
inc.addQuery('sys_id', '!=', current.sys_id);
inc.addActiveQuery();
inc.query();
if (!inc.next()) {

var parInc = new GlideRecord('incident');
parInc.addQuery('sys_id', current.parent_incident);
parInc.query();
if (parInc.next()) {
parInc.state = 6;
parInc.active = false;
parInc.update();
}
}

[Chander Bhusha1]

Hi Vijay,

The abort action is working fine and the error is also getting displayed but there is some other BR which is running and changing the state to resolved.

I simulated the same in my PDI and it was working fine and state is not setting to resolved.

Can you check if there is any customization done in your instance. And are you using before BR only. It should be in before BR only and can you share the screenshot of the BR which you have written

There is some other BR is running which is making the update .

Thanks,

CB

[Vijay8]

Hi CB,

May I know which Instance you are using (Like- NewYork, Orlando)

[Vijay8]

If I write the code below it is working fine but, when all child incident's get closed then parent is not closing

(function executeRule(current, previous /*null when async*/) {
 
var target = new GlideRecord('incident');
 
    target.addQuery('active','true');
 
target.addQuery('parent_incident',current.sys_id);
 
target.query();
 
if (target.next())
 
{
 
current.setWorkflow(false);
 
current.state = previous.state;
 
gs.addInfoMessage('Please close child task');
 
gs.setRedirect(current);
 
current.setAbortAction(true);
 
} })(current, previous);

[Chander Bhusha1]

Hi Vijay ,

I tried in Madid and Orlando both are working fine.

The BR is on incident table and condition is -- state changes to resolved.

 It aborting the action and only on the form it will show for some time but in the backend it will not save. Try reloading the page once you click on resolve button it wil show you error and if you reload the page it won't set the value.

May be you are just referring the client side.

script:

	if(JSUtil.nil(current.parent_incident)) //Checking if this is parent incident or child incident
{//If it is parent incident then only it will proceed

//Update all the child tickets
var inc = new GlideRecord('incident');
inc.addQuery('parent_incident', current.getUniqueValue());
inc.addActiveQuery();
inc.query();
if(inc.hasNext()) {
gs.addErrorMessage('You cannot close the parent ticket until the child incident are closed');
current.setAbortAction(true);

}


}

Screen shot:

Script : 

Mark helpful and correct if it works.

Thanks,

CB

[Vijay8]

Hi CB,

It's working fine Thank you

But, after closing last child incident parent should automatically close it's not closing