That should work.  I was able to take your query, put in a property name (and
add a ISDESCENDANTNODE clause) and it works for me. Are you getting an error?

-----Original Message-----
From: Lukas Kahwe Smith [mailto:[email protected]] 
Sent: Monday, August 29, 2011 10:08 AM
To: [email protected]
Subject: IS NULL

Ahoi,

I'm trying to do a query that will return all the documents that don't have a
property set up for example I would like that:

SELECT * FROM [nt:unstructured] WHERE [nt:unstructured].myPropertyName IS
NULL ORDER BY SCORE() DESC

Will return all the docs where the property "myPropertyName" is not present. 

How can I write such query?

Thanks,
Lukas Kahwe Smith
[email protected]



Reply via email to