AND "Epic Link" NOT IN (XXXX-XX) excludes empty Epic link as well, why ?

[JIRA Autobot]

Hi,

Making a JQL querry like AND "Epic Link" NOT IN (XXXX-XX) excludes all the issues that have no Epic links but that was not expected. It was expected to show a list of issues which did not have a link to XXXX-XX but YYYY-YY AND the empty ones but those are excluded. Is this a bug or intentional ?

donnib

[Christian Czaia [Decadis AG] · Accepted solution]

Try

AND ("Epic Link" NOT IN (XXXX-XX) OR "Epic Link" IS EMPTY)

In general you have to always take a special look at EMPTY (null) values since they are handled differently in JQL. For example "color != "red"" returns all issues that HAVE a value but that's NOT RED.

Cheers

Christian

[Ethan Kim]

Thanks!

[JIRA Autobot]

That did the trick although i would have guessed the JQL i made first time "should" have worked ;)

Thank you :)