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

JIRA Autobot September 9, 2013

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

2 answers

1 accepted

6 votes
Answer accepted
Christian Czaia _Decadis AG_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 9, 2013

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 February 11, 2019

Thanks!

Like Jeremy Conn likes this
0 votes
JIRA Autobot September 9, 2013

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

Thank you :)

Suggest an answer

Log in or Sign up to answer