JQL to show Epics where child issues have specific fixVersion applied

[Mark Quinteros]

Hi All,

I would like to have a filter that does what the title says.

Basically, we to just show Epics with Stories/Bugs/Defects/Tasks that have specific fixVersions applied to those child tasks.

Searching here didn't yield results.

Thanks!

[mauricio.groth · Accepted solution]

Hi @Mark Quinteros 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find your epics that have children in a specific FixVersion

issue in epicsOfChildrenInQuery("fixVersion = X")

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Mark Quinteros

welcome to the community!

JQL isn't too great with querying "across" parent/child relationships, so to the best of my knowledge, you'll need a Marketplace app to do that.

Two ways forward:

There's a number of apps in the Marketplace that extend JQL. JQL Search Extensions, for example, has an "epicsOfChildrenInQuery" function, which might help here.

Alternatively, there's a number of hierarchy-focused apps in the Marketplace. These apps typically don't rely on "plain" JQL, but have their own ways of establishing and searching through parent/child relationships between issues. I can only speak for the app that my team is working on, JXL for Jira - but here, it would be very easy to model your use case:

• Create a JXL sheet that includes all relevant stories/bugs/defects/tasks with the given fix version, and any potential epics. Don't worry about parent/child relationships; JXL will sort this out for you.
• In your sheet, enable the default hierarchy. That's a one-click action.
• In your sheet, hide all top-level issues without children. That's again a one-click action.

The resulting list of epics is what you're looking for. This is how this looks in action:

You may already know that you can trial any app for free for 1 month, and depending on the size of your site, it may be free forever. So perhaps give some apps a try and see which one works best for you!

Hope this helps,

Hannes

[Mark Quinteros]

hi thanks for the tips!

since these aren't JQL queries, can they be imported into Confluence docs? the goal here is to have them added into release notes.

Thanks!