-
Type: Improvement
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: 5.3 GA
-
Fix Version/s: 5.4.2
-
Component/s: Core VCS, Query & PageProvider
-
Tags:
NXQL do not support expression that assert null values.
For instance, executing the query:
SELECT * FROM Document WHERE dc:title IS NULL
will produce the following error :
org.nuxeo.ecm.core.api.ClientException: Failed to execute query: org.nuxeo.ecm.core.query.QueryParseException: Syntax error: Invalid token <IS> at offset 37 in query: SELECT * FROM Document WHERE dc:title IS NULL
at org.nuxeo.ecm.core.api.AbstractSession.query(AbstractSession.java:1404)