Forums

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

Jira filter doesn't show items with empty parameter if use '!='

Alex Gych
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 30, 2021

Hi

If I use search 

 

project = [project name] AND labels != [label1] 

 

it should display ALL items without [label1], but it doesn't show items without labels at all

 

it's working properly only if use:

 

project = [project name] AND (labels != [label1] OR labels is EMPTY)

 

but why?

condition 'labels != [label1]' the same as empty label (because provided label is not present in the item - so it should be found successfully)

1 answer

1 vote
Jose Luis Gaitan
Community Champion
September 30, 2021

Hello, @Alex Gych ;

The "!=" operator doesn't work with fields that has no value, so if you want to show null values too, you must do using the "is EMPTY" operatos, as you did it.

Please, see this link for more information about this operator:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/

Alex Gych
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 30, 2021

yep, i understand that it doesn't work, but it's so confusing.

 

when i use operator '!=' - i expect that it will display all items without this parameter (even if parameter is empty). 

So for me, answer 'it's not a bug - it's a feature' shouldn't be in this case.

Nic Brough -Adaptavist-
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.
September 30, 2021

It's not a bug, it's working as intended.

Suggest an answer

Log in or Sign up to answer