Filter: How to surface epics with a condition on child issue

[Justine]

Hi! I have the following configuration:

- Epics

- Tasks with different labels

I am trying to create a filter that surfaces the tasks with a specific label as well as their Parent Epic (which don't have any label)

Is there a straightforward way to do this?

Thanks for you help!

[Najm Polaris]

Hi Justine, 

Filter with the given label that you want and from the "Columns" select the "Epic Link". This would filter all the issues with the given label and the table would show its respective epic name.

[Hannes Obweger - JXL for Jira]

Hi @Justine

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:

• You should be able to use Jira Automation to "propagate" the information from the tasks up to their epics, and then use the respective field on the epics 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. I've used JQL Search Extensions a few times and it works great. The (potential) disadvantage is that you'll always only see your issues as a flat list, rather than in their hierarchy.
• 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.

Put simply, you'd load relevant issues into a JXL sheet, enable the default hierarchy (that's just one click), and then use JXL's various column and hierarchy filtering capabilities to narrow the result down to what you're looking for. This is how this could look in action:

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 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!

[Justine]

hi, thanks!

Automation is indeed a good option I hadn't considered.

In regards to the other solutions, for the moment I'm trying to solve this without increasing the price of our subscription - thanks for the links though!

Have a nice day

Justine