Filter for fixVersion and stories

Question

Hello!

I have a question about filter for fixVersion.

I need to create QuickFilter with next parameters:

1. As result I should get the list of issues that are in some fixVersion (for example, fixVersion = "1.0").

2. At the same time I need to see issues that have sub-tasks (without links to fixVersion in the sub-tasks).

Maybe, you can help me with that.

Thanks!

Daniel Turczanski - JQL Search Extensions · Answer

JQL filtering is powerful but you can hit its limits in more complex workflows.

You can filter in Jira on many issue fields. There's version filtering, project, system fields, and custom fields - all useful. What standard JQL is missing are functions for analysing the issue relations and dependencies.

So, if you're serious about JQL you should look beyond standard Jira.

Our app that Martin recommended on this thread, JQL Search Extensions, is an answer to many popular JQL scenarios that you encounter every day.

For example, in your quick filter, you can use the subtasksOfParentsInQuery JQL extension:

fixVersion = "1.0" OR issue in subtasksOfParentsInQuery("fixVersion = '1.0'")

Alternatively, you may be able to work around any JQL reporting limitations with an Excel export. This doesn't work well if you want to create a quick filter for the board though.

Martin Bayer _MoroSystems_ s_r_o__ · Answer

Hi @Oleksandr Olasiuk , welcome on the community. I'm sorry but I'm afraid there is no built-in JQL function to display issues with subtasks. There is a ticket created for this feature (https://jira.atlassian.com/browse/JRACLOUD-67108). You can find some workaround in there but it requires to use Script Runner or JQL Search Extensions for Jira & reports App. Do you have any of these installed?