Issue with filtering

[Aliaksandr Maletski]

Hi Everyone,

When I'm using JQL search, and criteria as "not in" for any fields, e.g.

"Epic Link" not in (EN-13219) ;
"QA Status" not in ("Not Required")

it is showing the all items with some value in "Epic Link" or "QA Status", but does not show the items with EMPTY value in "Epic Link" or "QA Status".

So, I have to force Empty value on to get right results:
"QA Status" not in (EMPTY, "Not Required");
"Epic Link" not in (EMPTY, EN-13219) ;

From user point of view, the expectation is extract all items which do not have provided Value by "not in", but in reality we need to keep in mind EMPTY value to be filtering. 

Please, let me know if we can resolve this inconvenient or it is kind of requirements.

Thanks, 
Alex

[Mehmet A _Bloompeak_]

Hi @Aliaksandr Maletski ,

It is a known behavior or a problem depending how you see it. There is the open ticket waiting for Atlassian to solve. You can vote on it.

https://jira.atlassian.com/browse/JRACLOUD-61841

[Bhushan Nagaraj]

Not sure I understand your requirement.

List all issues with QA Status empty or not equal to "Not required"

Issue Type in (Story, Bug, Task) AND QA Status is EMPTY or QA Status != "Not Required" and Epic Link IS NOT EMPTY