How to search for items whose parent/children have a specific type ?

Question

Hello everyone, I have noticed several inconsistencies in my backlog and I would like to build a filter to find out all the inconsistencies. For instance, I'd like to know if I have Epics whose parent is also an Epic (I've been told it's impossible, but I do have some examples in the backlog). I need help to build this kind of filters : * whose parent has * whose at least one child has Thank you !

Bartek Szajkowski _ Orbiscend OU · Answer

Dear @magali_lamande

Hope my answer meets you well.
I'm Bartek from Orbiscend OU.

If you are open for third-party app, I could recommend to try ARGON app
Available on Marketplace.

ARGON Powerful JQL Search

ARGON Powerful JQL Search can help you find these inconsistencies using the childrenOf function.

This uses Argon's childrenOf  function to find any Epics that appear as children of other Epics.

You can extend this to catch other common inconsistencies in one combined filter:

ARGON offers significantly more search and filtering capabilities. Feel free to explore them on the Marketplace page.

I hope my suggestion helps you resolve your issue.

Greetings
Bartek
Orbiscend OU

Aaron Pavez _ServiceRocket_ · Answer

Hi @magali_lamande AFAIK, an EPIC cannot have another EPIC as a parent. Check the issue types you have, and it could be another work type higher in the hierarchy called Epic? Can you send us a screenshot of how it looks? Hover over the work type icon in the work item, and check the names. > I need to help to build this kind of filters : * whose parent has * whose at least one child has Not possible with native JQL. you might need scriptrunner for this or another third party app. What JQL can do is to find a Task with an EPIC = "name of epic" The second one could be done like this: issuetype in (Story, Task) AND parent is not EMPTY Regards