jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lukas Kahwe Smith <...@pooteeweet.org>
Subject IS NULL
Date Mon, 29 Aug 2011 14:07:49 GMT
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
mls@pooteeweet.org




Mime
View raw message