JQL: find Epics, which children are under a particular condition

[Anita Sudan]

Hello, 

I have a JQL question:

I need to find all Epics, which children are under a particular condition.

So for example, I need to get all epics which children tasks or stories have label "creative"

Would appreciate if you help me with the JQL!

Thanks a lot!

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Anita Sudan

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

• You may be able to "propagate" the information from the children up to the parent using Jira Automation, and then filter by the respective field on the parent.
• There's different apps from the Atlassian Marketplace that can help with that. As Florian said, there's a number of apps that extend JQL by additional functions, including hierarchy-related functions. I've used JQL Search Extensions a few times and it works great, but there are others, too. 
• 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 last point, this is how this would look in the app that my team is working on, JXL for Jira; TLDR: You'd create a sheet with your relevant issues, enable the default hierarchy (that's just one click), and then use JXL's various filtering capabilities to narrow down your list of issues:

Once you have 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 may be other apps that help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Any questions just let me know!

[Anita Sudan]

Thanks a lot for your help!

I'll look up some apps then

[Florian Bonniec · Accepted solution]

Hi @Anita Sudan 

Due to Cloud limitation I'm not sure it's possible. You can achieve part of that using an app such as Scriptrunner with epicsof function.

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

Note that only works when running the query, last time I used it, saving the query only save the result of the query not the query itself, so if there is a new epic that match the JQL it will not be return by the filter you will have to run the query again.

Regards

[Anita Sudan]

Thanks!

[mauricio.groth]

Hi @Anita Sudan

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.

As an alternative to what Hannes said, you could check the app where my team works, JQL Search Extensions for Jira, and use this query to find all your epics that have tasks or stories where the label is "creative"

issue in epicsOfChildrenInQuery("type in (Story, Task) and labels = creative")

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 @Anita Sudan 

As mentioned by other community members an app can help to get this data.

If you are fine with it, 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 issues using JQL.

Disclaimer : I work for the vendor who built this app