JQL for all Epics with issues (TASK)

[David Verbeure]

I am looking for a JIRA JQL to see all EPICS with underlying tasks. I don't want to see Epics without tasks

[Prosper Agwegiokhe]

Hi @David Verbeure ,

I’m Prosper, a support engineer at Appfire, and I’m here to help.

If you are open to a pluggin solution, you can try out our App JQL Search Extensions for Jira.

You can use this query below:

issue in childrenOfEpicsInQuery("epic") 

to get the children of an "epic".

You can see more information about this query here, and please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Prosper.

[Sarp Egemen]

Hi @David Verbeure ,

I don't think this is possible with native JQL. However, you can use an app that adds an expression for that to JQL and then use this query:

"issuetype = EPIC AND issueFunction in hasLinkType("Parent-Child")"

Here is the Scriptrunner app that adds this functionality to JQL. I am not affiliated with them; you can check it out to see if it fits your needs in terms of functionality and price.

https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?tab=overview&hosting=cloud