How to select issues with only one Fix version

Maksym Kalyta June 19, 2013

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?

5 answers

1 accepted

2 votes
Answer accepted
C_ Faysal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 20, 2013

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 July 16, 2019

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 September 23, 2020

Is there another (new) solution, which works?

0 votes
Dmytro G May 30, 2019

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

AND (fixVersion < Rel1 OR fixVersion > Rel1)
Gary Miner July 16, 2019

This does not work.

Dmytro G July 16, 2019

Hi @Gary Miner 

It worked well for me.

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

Andreas Völkl September 23, 2020

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

0 votes
Maksym Kalyta June 20, 2013

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

0 votes
C_ Faysal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 20, 2013
What if you choose fixVersion = "Rel1" ? Will this show issue #1 too?
C_ Faysal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 20, 2013
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 June 20, 2013

sure it does - that's the problem

0 votes
Maksym Kalyta June 19, 2013

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.

Suggest an answer

Log in or Sign up to answer