jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mark Herman" <MHer...@NBME.org>
Subject RE: IS NULL
Date Mon, 29 Aug 2011 14:32:52 GMT
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:mls@pooteeweet.org] 
Sent: Monday, August 29, 2011 10:08 AM
To: users@jackrabbit.apache.org
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
mls@pooteeweet.org




Mime
View raw message