use lowercase null:
e.g.
select Name,ParentProject from Project where ParentProject=null
Comment actions
Hi,
I'm trying to build a query in CZQL that basically checks if a field is blank. I'm trying with things like "C_MyField = NULL", "C_MyField IS NULL", "C_MyField ISNULL" but nothing seems to work, I always get syntax errors. What is the right statement to check for null?
Thanks.
Please sign in to leave a comment.
use lowercase null:
e.g.
select Name,ParentProject from Project where ParentProject=null