Filter to show parent incidents

[paulsheraton]

Hello

How do we create a filter to purely just show open parent incidents?

Cheers

Paul

[sanjay36]

You can create a filter saying parent is not empty then you can see all the incidents which are parent to any other incident.

[sanjay36]

Can you do a Group by parent and see if there are multiple incidents tied to one parent incident or vice versa.

[Sagar V1]

Hi Paul,

Create the below filter in "sys_filter" table

And select the filter in Incident table to get the output

Regards,
Sagar

PS : Hit Like or Correct on the impact of response.

[paulsheraton]

Does not work again is showing over 3000 incidents...

[Sagar V1]

Check whether "Parent Incident"   column contains the value of Parent incident number or any other field is used to relate the Parent and Child tickets