JQL to find all tasks with open Epic

[Javid Huseynli]

Hi,

I would like to find all tasks which have open Epics. 

How can I do it with JQL? 

[Hannes Obweger - JXL for Jira]

Hi @Javid Huseynli

unfortunately, "plain" JQL isn't too great with hierarchies, so to the best of my knowledge, you'll need extra tooling to solve your use case. A few directions forward:

• I haven't tried it myself, but this should be possible in Advanced Roadmaps, since it has great support for issue hierarchies. If you create a plan that contains all the relevant epics, plus any potential children, AR should show the children under their epics, and all other children in a special "other issues" "basket" that you can ignore.
• You should be able to use Jira Automation to "propagate" the information from the epic down to its children, and then use the respective field on the child issues in your JQL.
• There's different apps from the Atlassian Marketplace that can help with that. On the one hand, there's a number of apps that extend JQL by additional functions, including hierarchy-related functions. See Mauricio's answer for how this is done in JQL Search Extensions.
• Alternatively, you could try one of the more hierarchy-focused apps from the Marketplace. These apps typically have their own ways of figuring out parent/child relationships between issues, and provide more powerful ways to define and navigate through issue hierarchies. I myself work on such an app, in which your use case would be easy to solve; I'll provide more details below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on the latter, this is how this would look in the app that my team is working on, JXL for Jira; TLDR: You can simply load your relevant issues into a sheet, enable the default issue hierarchy (that's just one click), and then filter down to the epics that you care about:

Once you've narrowed down your list of issues, you can work on these directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export them for further processing.

As said above, there are other apps that may help with that - so perhaps try a few and see which one works best for you!

Any questions just let me know,

Best,

Hannes

[mauricio.groth]

Hi @Javid Huseynli

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your tasks that are children of an open epic.

issue in childrenOfEpicsInQuery("status = open") and type = Task

Please contact our support if you have any other questions about this query. 

We’ll be happy to help you!
Best regards,
Maurício

[Rahul_RVS]

Hi @Javid Huseynli 

If you are fine with a mktplace app doe a readymade solution, you can try out our add-on.

Issue Hierarchy Reports 

The app will show you the default Epic Hierarchy and also let your filter on the child issue statuses.

Disclaimer : I work for the vendor who built this app

[Meghan LaClair]

Hi @Javid Huseynli 

Unfortunately as the others have mentioned this isn't something that JQL is capable of quite yet. If you are open to 3rd party solutions we've created an automated solution for this at minware. 

Our predictive roadmap automatically shows dependencies, and weighs weekends when calculating remaing Dev days. You can roll down from epic to subtask for a detailed view of WIP/completed work/planned work. We also offer a breakdown by task assignee so that you can coordinate with your team, regarding open tickets.

Since our dashboards are created by uniquely combining version control, ticketing, and calendar data we can provide full transparency in one plug and play solution. 

We offer a free trial, if you would like to check it out please let me know!

Disclaimer: marketplace partner