How do I filter for parts of the FixVersion/s field?

[Gero Kassen]

It is possible to search for parts of what is written in the summary field (with ~). I want to do the same thing for the FixVersion/s field. Is this possible?

In general my concern is, that I have Releases that have a specific nomenclature and I want to filter for the issues that are subordinated, based on parts of this nomenclature. Is there a possibility to do this without the use of Add-ons/labels etc.?

[Alexander Ling · Accepted solution]

According to https://confluence.atlassian.com/jiracorecloud/advanced-searching-fields-reference-765593716.html?_ga=2.228522654.2094838208.1569828953-503707675.1567420743#Advancedsearching-fieldsreference-FixVersionfixVersionFixversion 

The ~ character is not supported for queries with fixVersion.

But you can use fixVersion in situations like these:

fixVersion in ("3.14", "4.2")

or

fixVersion = "hello"

Hope this answer your question!

[Gero Kassen]

This answers my question, but does not provide a solution. Too bad, that the Fix Version field cannot be accessed by the ~ character. This means there is no "Out-of-the-box"-Solution for just filtering for segments of the Release name, too bad, as Releases do not have any other attributes that can be filtered for.

[Mark Moore]

This doesn't work for me, as the "IN" syntax requires an exact match, if you try to use partial, it doesn't work, in fact, you get a error that the Value you entered does not exists in fixVersion.   The solution below, however, doesn't work .

[Tomasz Drabik]

I've just found out that this seems to work now: 

fixVersion ~ "*keyword*"

[Jason Cox]

Works great!  I saw reports in other places that this solution doesn't work, but I just tested and it worked for me!  Thanks Tomasz! 

[Konstantin Demidov]

Thank you Tomas!

[Tomasz Drabik]

.

[Wilbert Bus]

Great, that worked too for me!

[Mark Moore]

Thanks, I knew there had to be a way to do this...

[Monica LaRue]

Why would this syntax work for some  and not others?   It does not work for me. 

[Maryann Rieger]

Thank you!  was missing the wildcard * before and after the keyworkd - that resolved my problem

[Jan Sękara]

Great Tomasz, thanks for that!

[fran garcia gomera]

the ~ can only be used in JQL for the fields that are defined as free text searchers, fix version is a select list field.

with scriptrunner you have a function that fits your needs

fixVersion in versionMatch("^RC.*")

 https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_projectmatch_componentmatch_versionmatch 

I guess the free addon SQL to JQL would work for you too (haven't try it)

[Gero Kassen]

Thank you for your answer. An addon sadly does not solve the problem, because it is not possible to intall them, even when they are free of charge, due to the Company's IT structure.

[fran garcia gomera]

Ok, maybe you could do some workaround like copying the version value to a text field and filtering for this new field.

[Gero Kassen]

Yes, this was now the way to go. I wanted to avoid manual work, but unfortunately Atlassian does not provide an out-of-the-box solution (like in many other cases). Thanks for the support.