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

Ulrich Prakash May 15, 2019

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

1 answer

1 vote
Alexey Matveev
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.
May 15, 2019

Hello,

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

Ulrich Prakash May 15, 2019

Hi,

 

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events