View Incidents where all tasks are closed

[M_Gilbert]

Hi,

We have a use case where we want to see Incidents where 'ALL' Incident Tasks are closed.  If 'any' incident task is open then this should be filtered out.

Example

So if an Incident has 2 tasks (1 Open and 1 Closed) this should be filtered out.  If both tasks however are closed then it should be included.

Can't see how this can be achieved.

[Adam Stout]

This isn't correct.  This will look for closed, but I believe we want to look for not open in this case.  So it should be "None" active incident tasks.

[Yash Agrawal1]

HELLO ADAM,

Priyanka gave the correct solution,as the requirment is to find to all the incident which's ALL TASK ARE CLOSED.

I also checked the solution priyanka provided.I is working correctly.

Her provided solution is giving incident where its tasks are closed.

You can also try it once.

Regatds

Yash Agrawal

[Adam Stout]

The screenshot gives you where there is one or more closed complete tasks.  It does not look if there are open tasks.  You have to look if there are no open tasks.  This doesn't work if you need to have at least one task to begin with (you would need two RLCs for that which is not supported).

Find an incident with one open task and one closed.  As I understand it, you would NOT want this in your result set, but I bet it comes back given the solution above.

If you are getting what you expected, then perfect, but be sure to test thoroughly.

[M_Gilbert]

Hi, I'm not sure that would work.

I believe this will bring back all Incidents which have at least 1 task in closed complete.

So if an incident had 2 tasks as below then this would probably get returned in the query as at least 1 is closed.  That would not meet the use case as I am trying to filter the incident to see if 'ALL' tasks are closed.

> Task A - Open

> Task B - Closed

[Sailesh4]

Hi,

Can you please elaborate the Use case.?

If you want to see the incidents which are not having any active tasks assigned to it in Report, then you can do it using the related lists as Priyanka said. Or if you want to get the list of incidents from background scripts, please use the same script in background script as Yash said.

Please mark as correct if this solves your issue or mark as helpful.

Thanks,

Sailesh J