Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL error for FIXVERSION = "None"

Andy - PTC Redundant
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.
December 16, 2019

So, I'm not a JQL master... I think I use max once every two - three weeks... LOL.

That means I get stumped easily on really easy basics and so here's a dump question:

How do I search DONE issues that do NOT have a fix version...?

JQL_FixVersion_NONE_b.jpg

 

This JQL is good and gets desired result:


project = "ENVIS" AND statusCategory = Done ORDER BY updated DESC

 

This JGL is NOT good and I get a warning message:


project = "ENVIS" AND statusCategory = Done AND fixVersion = "None" ORDER BY updated DESC
The value 'None' does not exist for the field 'fixVersion'.

JQL_FixVersion_NONE.jpg

 

My gut feeling tells me I should be pouring through this in more detail:

https://confluence.atlassian.com/jiracorecloud/advanced-searching-765593707.html 

But I'm lazy, love hanging out on Community, and I'm sure someone would LOVE to get an extra Accepted Answer today....! 😉🏆

2 answers

2 accepted

4 votes
Answer accepted
Alex Laycy
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.
December 16, 2019

Hi @Andy - PTC Redundant ,

 

If you use the below, you should hopefully get the answer you're looking for! 🤓

 

 project = "ENVIS" AND statusCategory = Done AND fixVersion = EMPTY ORDER BY updated DESC

 

- Alex

Andy - PTC Redundant
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.
December 16, 2019

Super awesome @Alex Laycy ! 🏆🌟👌
I don't even need to type... just copy/paste your suggestion! Bing bang! Thank you kindly 🙏😇

Like Paul Adkin likes this
3 votes
Answer accepted
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 16, 2019

Try fixversion is Empty

Andy - PTC Redundant
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.
December 16, 2019

OMG... really....??
"empty" instead of "none" ?? Even though Jira cloud is showing status "None" on my screen....?
LOLz - silly Jira! 😜

Thanks @Jack Brickey ! Much appreciated. 🌟👏

Suggest an answer

Log in or Sign up to answer