Why my JQL search with "not in" or "!=" (not equals) operators has issues missing (1018766307)

Question

Hello Community/JIRA

Do you have any idea why to add IS EMPTY statement when NOT IN clause is used is considered as a feature. (KB reference)

I consider it as a bug. Nobody is thinking in the direction to add IS EMPTY when searching for something what is not in the list. It took long hours to user to find how to get a list what he needed.

Any explanation will be appreaciated

Vlada

Vladimir Cech_tvehen · Answer

@Vishal Biyani,

Thank you for a quick response. By I'm not comparing NULL (Empty).

I want to know what issues does not contain concrete value in the field. When the field is empty it does not contain that value but it's omitted from the results.

Even from the programmer point of view it does not make sense. How common users shall find/know it?

Vishal Biyani_2pr07j · Answer

@Vladimir Cech

in SQL comparing NULL (Empty) value with value may not give right results.

Therefore, for specific use cases is EMPTY needs to be checked.