How many incident tasks are closed for incident

[String]

Hi Team ,

How to check ,how many incident tasks are closed for respective incident using script 

Please guide me with best practice 

[OlaN]

Hi,

Could you please clarify a bit on your use case?

At what point do you want to check how many incident tasks that are closed?

For example, should the check happen when the incident is updated, or when the incident task is updated?

[String]

Hi @OlaN 

we are receiving the inbound update ,So I have to resolve(state) the incident only when all the incident tasks are in closed state .

So need to check all the tasks are closed for respective incident or not 

[OlaN]

In that case I would do a business rule that looks something like this;

Do note, that this example does run on all attempts to set the incident to resolved.

I can imagine that you might need to consider if allowing the end user to close their own incidents, so you might need to add some additional conditions.

Script:

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

	var incTaskGR = new GlideRecord('incident_task');
	incTaskGR.addQuery('incident', current.getUniqueValue());
	incTaskGR.addActiveQuery();
	incTaskGR.query();
	
	if (incTaskGR.hasNext()){
		gs.addErrorMessage('Cannot resolve incident, is still has open incident tasks');
		current.setAbortAction(true);
	}
	
})(current, previous);

[Chetan Mahajan]

Hello @String ,

                              You can try below script to find out closed count task of respective incident in background script.

// Get the current incident record
var incident = new GlideRecord('incident');
incident.get('sys_id', '<incident_sys_id>');

// Query the Incident Task table for closed tasks related to the incident
var taskGr = new GlideAggregate('incident_task');
taskGr.addQuery('incident', incident.sys_id);
taskGr.addQuery('active', false);
taskGr.addQuery('state', '3');
taskGr.addAggregate('COUNT');
taskGr.query();

// Get the count of closed tasks
var closedTaskCount = 0;
if (taskGr.next()) {
  closedTaskCount = taskGr.getAggregate('COUNT');
}

gs.info('Closed tasks for incident ' + incident.number + ': ' + closedTaskCount);

Kindly mark correct and helpful if applicable.