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?

[ianparkinson]

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_]

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_]

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]

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

[ianparkinson]

@Jamie Echlin (Adaptavist) thanks for taking a look....

You have versions: A, B, C

You have 3 bugs: #1 affects A, #2 affects A & B - but was since fixed on A, and #3 affects C

So the filter should show 1 bug for each even though there were technically a total of 4 affects versions on those 3 bugs:

Version A: 1 bug

Version B: 1 bug

Version C: 1 bug

[JamieA]

this is not very clear, add some sample output...