How to exclude Done Epics and their child issues from a filter

[Chloe Fielding]

I am trying to create a list of all issues for a project which excludes any "Done" Epics along with all the child issues linked to that epic. So far I have managed to exclude the "Done" Epics, but can't find any solution to also exclude the linked child issues.

I have also tried inverting the filter to show only "Done" Epics, and saved it to try and use it as a reference to no avail.

I am only able to use basic JQL as there is no access to any add-ons via the business.

[Jack Brickey · Accepted solution]

Hi Chloe, welcome to the community.

So should we infer that the epic's children may not be in the Done state? Also, are you wanting to exclude or include issues that are not linked to Epics?

If you want to find issues that are unresolved forgiven project then one of the following should work.

project = ABC and resolution is empty (note that this requires you to set the resolution any issue when moving to a done status)

project = ABC and statuscategory != done

If you want to only include issues in Epics then...

project = ABC and resolution is empty and (type = epic OR "parent link" is not empty) (note if youy are using TMP projects replace "parent link" with "parent")

project = ABC and statuscategory != done and (type = epic OR "parent link" is not empty)

Finally, note that you can use advanced JQL natively without addons. simply click on Switch to JQL

Please let me know if any of this helps or if I could be of further assistance.

[Chloe Fielding]

Hi Jack

Thanks - I've had a try with the above and this one:

project = ABC and resolution is empty and (type = epic OR "parent" is not empty)

seems to get the majority of results. However, I would like to keep in Done child issues for In Progress parents. I tried adding an OR statement in following "resolution is empty" but that came back with everything!

I have a saved filter that gives me a list of all the Done Epics: "FI - Done Epics", I was think if that can be used a x-reference? 

[Jack Brickey]

How about this...

project = ABC and (resolution is empty and (type = epic OR "parent" is not empty)) OR (resolution is not empty and parent is not empty)

[Chloe Fielding]

Initially came back with results for all projects, so I tweaked slightly to

project = ABC and (resolution is empty and (type = epic OR "parent" is not empty)) OR project = ABC AND resolution is not empty and parent is not empty

[Jack Brickey]

So are you good to go here? Should we consider this one complete an answered?

[Chloe Fielding]

Thanks Jack!