Hello Team,
What's the difference between the 2 when it comes to search in JQL?
Victor
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
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.
It looks like you're new here. Sign in or register to get started.