When I create a filter where field != value, the results do not show field = EMPTY issues.
A workaround is to do (field != value OR field = EMPTY) but I was told that this was not the way it used to be so I was wondering if there is a setting for that.
No, it hasn't changed.
"Does not equal" is not quite the same as "empty" because != says you're looking for a specific value to not be there. If there's no values to look for, you can't say that your selection isn't there because there's nothing to look for.
Well, not since JIRA 3, which didn't have JQL, so you didn't have != or empty.
It's a little bit confusing for humans, because of our fuzzy thinking. Even a "yes or no" question really has three "answers" - yes, no, and not answered.
My friend explained it by saying "show me a picture of your black cat", then "show me a picture of all your cats who are not black", then "show me a picture of your dog who is not black". I don't have a dog, so I have to look for "empty" rather than "not black", because there's no dog there to not be black. (I love English negatives. Not)
Dang humans. Makes perfect sense to me, but my customer is still not happy. His concern is that in the future he will forget to use the "OR field = EMPTY" and miss records in his reports. I told him I could change the field to required and create a dummy value (called it "no value") and set that as default. Then go through with bulk change and find all issues with EMPTY values and change them to "no value", but I really do not like that solution as it adds even more clutter in my instance. Any thoughts on that solution?
Does this work around actually work. The Or function returns the values as if they were a separate query? So you end up with the results you excluded by using != in the = EMPTY results ie.
(Pet Type != dog OR field = EMPTY)
Which translates to. Show me everything that is not a dog, and show me everything (including dog) that is not empty
Dog, Empty, Cat
Not the expected
Yes, using the right JQL does "work". There's an important thing to understand here - JQL is not SQL and it has nothing to say about the results are returned. When you "run" some JQL, all that the calling process gets back is a list of issues that matched the query.
Also, empty really does mean empty - there is nothing there in the database for an empty field, nothing at all. So in fact you can't say:
Because all you have is
(And that's why != does not return the results, it's got nothing to compare with at all)
Your query translation is not quite right by the way
You said: "Pet type != dog or field is empty", which means "Show me all issues with a Pet type where it is not dog, and all issues that do not have a value in "field"". I'm guessing the issues being returned that have "Dog" on them have nothing in "field"
I think you might mean "Pet type != dog or Pet type is empty", which would give you issues with no Pet type and issues with Cat
Jira is a great tool to use across different departments. Forget that paperwork – switch to Jira and get that tasks done smoothly. Marketing Jira allows for a complete digital transformation of you...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events