How to create a JIRA filter to track all bugs across several versions in a project, but exclude a bug from a version if it has that version in the fixed version field?

Question

One project, multiple versions, bugs only

This is the goal:

Track all non closed bugs in that project across all versions and display the results broken out by version – but do not display a bug for a version if that version appears in the fixed version field.

Ravi Sagar _Sparxsys_ · Answer

Well this is not possible in JQL.

project = "PROJECTKEY" and issuetype = Bug and fixVersion not in (RETRIEVE ALL THE VERSIONS OF THE BUGS)

You can try a simple JQL like this.

project = "PROJECTKEY" and issuetype = Bug and fixVersion is EMPTY

Or try SQL for JIRA plugin to write complex queries. Here is the link: https://marketplace.atlassian.com/plugins/com.kintosot.jira.jdbc4jql/server/overview

Jamie Echlin _ScriptRunner - The Adaptavist Group_ · Answer

I doubt you can do that in plain JQL. You could either write a report, gadget, or your own JQL function, or look at one of the reporting plugins available for jira.

ianparkinson · Answer

The problem I'm running into - from the example above - is that if I exclude the ones with a fix version of A, it removes that bug from counting against the affects version of B