null vs empty

[Victor Mutambuki]

Hello Team,

What's the difference between the 2 when it comes to search in JQL?

Victor

[Johan Soetens _Dumblefy_ · Accepted solution]

Great question, Victor.

As Ollie said, the docs for EMPTY and NULL look identical, both Cloud and Server.

I have it summarized as follows:

EMPTY and NULL are used to search for issues where a given field does not have a value.

The "is empty" statement tells JIRA to return only issues where the value of the field is blank (see Ollie's link where this could become relevant).

Note that EMPTY and NULL can only be used with fields that support the =, IS and IS NOT operators.

[Ollie Guan · Accepted solution]

Hello @Victor Mutambuki ,

No detailed comparison of the differences in the keyword reference.

BTW：The following post gives some reference suggestions.

https://community.atlassian.com/t5/Jira-questions/What-is-the-difference-between-JQL-quot-EMPTY-quot-and-quot-NULL/qaq-p/835994