How to select issues with only one Fix version

[Maksym Kalyta]

Is there an ability to select all issues that have particular fix version but excluding issues with that one and other fix versions.

For exmaple, I have issue #1 with fixVersion = Rel1, Rel2 and issue #2 with fixVersion=Rel1.
I need query and return issue #2 only.

Is this possible using advanced searching?

[C_ Faysal · Accepted solution]

ok here we go:

go get jamies script runner plugin first.

https://marketplace.atlassian.com/plugins/com.onresolve.jira.groovy.groovyrunner

with this one installed you can query exact matches as described here:

https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-issueFieldExactMatch%28subquery,fieldname,regexp%29

one examle for you:

i created two test issues.

#1 with fixVersions = v1,v2

#2 with fixVersions = v2

this is the JQL to use in advanced search to grab #2 only..

issueFunction in issueFieldExactMatch("project = TEST", "fixVersions", "[v2]")

cheers

[Gary Miner]

This doesn't work anymore as noted here. https://jamieechlin.atlassian.net/browse/GRV-673

It doesn't appear to have been addressed. 

[Andreas Völkl]

Is there another (new) solution, which works?

[Dmytro G]

In case someone is still looking for a solution, here is one small query that worked:

AND (fixVersion < Rel1 OR fixVersion > Rel1)

[Gary Miner]

This does not work.

[Dmytro G]

Hi @Gary Miner 

It worked well for me.

Just curious, could you please describe what are you trying to query?

[Andreas Völkl]

For me it doesn't work.
Is there another solution, which works?

[Maksym Kalyta]

Thank you, will take a look. It's bad there is no standard way in JIRA to do exact match query...

[C_ Faysal]

What if you choose fixVersion = "Rel1" ? Will this show issue #1 too?

[C_ Faysal]

I see. So you're asking for a query with an exact match. I will try something out and then let you know...

[Maksym Kalyta]

sure it does - that's the problem

[Maksym Kalyta]

To add - I would like to avoid counting all versions as in and not in.
So query
fixVersion in("Rel1") and fixVersion not in ("Rel2")
is not desirable.