Show all issues not in epic and exclude others from other epics

[Anna Gawliczek]

Hi, I need to show done bugs from a period of time, but the challenge is that I need to exclude bugs from 5 epic in that search and show bugs either not having epics at all or being in other epics than those 5. When I use below search I do not receive issues without epics:

project =  XXX AND issuetype = Bug AND created <= -6w AND resolved >= 2021-07-01 AND resolved <= 2021-08-13 AND filter = "XXX Squad Filter" and "Epic Link" not in (XXX, XXX, XXX, XXX, XXX)

Any ideas why is that? :)

[Marcin Szymkowiak]

Hi Anna :) 

You need to change the last part of your JQL to:

 and ("Epic Link" not in (XXX, XXX, XXX, XXX, XXX) or "Epic Link" is EMPTY)

From the docs: 

"The "NOT IN" operator will not match a field that has no value (i.e. a field that is empty). "

Check for more details: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/