Post

2 followers Follow
0
Avatar

How to check for null in CZQL

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.

Fernando Borrego Polo Answered

Please sign in to leave a comment.

1 comment

0
Avatar

use lowercase null:
e.g.
select Name,ParentProject from Project where ParentProject=null

Eyal Post 0 votes
Comment actions Permalink