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
Hello,
It is not a bug. It is a feature. You should add the OR condition
Hi,
First case is - not in (Functional, Enabler). EMPTY is also not in Functional and Enabler, right?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.