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

Anna Gawliczek_4z798j

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_d14xnc

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/