JIRA Query does not return "EMPTY" fields for != condition

Question

Hi,

I am giving a query to return the rows which are not Matching the given fields. But the query does not return EMPTY rows. Example:

ID     Story Type

1       Functional

2       Functional

3       Enabler

4       <Empty>

5       Non-Functional

My query is - "Story Type" not in (Functional, Enabler). I expect rows 4 and 5 to be returned, but only getting row 5.

When I give the query as - "Story Type" not in (Functional, Enabler) or "Story Type" is EMPTY, then only i get 4 and 5. However the expectation is i should get this in first query iteslf. Can you confirm if this is a bug and if it will get fixed in future release?

Regards,

Prakash

Ulrich Prakash · Answer

Hi,

First case is - not in (Functional, Enabler). EMPTY is also not in Functional and Enabler, right?

Alexey Matveev · Answer

Hello,

It is not a bug. It is a feature. You should add the OR condition