topic Re: porperty : NULL or unavailable in Lucene search in Alfresco Archive

porperty : NULL or unavailable in Lucene search

ajansen — Mon, 06 Aug 2007 13:34:19 GMT

I'm trying to build a query which also has to check for a property being NULL (or unavailable) but I have no idea how to do this.Every test is resulting in 0 result in every way I build the Query.Any help would be appreciated.

Re: porperty : NULL or unavailable in Lucene search

andy — Tue, 07 Aug 2007 09:32:06 GMT

Hi

You can use queries like ISNULL:"cm:name".

The performance may not be great, and could be improved, but it will work.

Andy

Re: porperty : NULL or unavailable in Lucene search

putodemonio — Fri, 09 Nov 2007 12:36:17 GMT

Hi!

I'm trying to find nodes with property fechapublicacion in namespase cice.salaprensa.model without value. I've try many versions, but it doesn't work anyway:


ISNULL:"@\\{cice.salaprensa.model\\}fechapublicacion"
ISNULL:"cm:fechapublicacion"
ISNULL:"\\{cice.salaprensa.model\\}fechapublicacion"
ISNULL:"cm:\\{cice.salaprensa.model\\}fechapublicacion"
ISNULL:"cm:@\\{cice.salaprensa.model\\}fechapublicacion"
ISNULL:"@cm:\\{cice.salaprensa.model\\}fechapublicacion"
‍‍‍‍‍‍‍‍

Please, may anybody help me!!!! :? :?

Re: porperty : NULL or unavailable in Lucene search

andy — Mon, 12 Nov 2007 16:31:05 GMT

Hi

It should work with
ISNULL:"cm:content"
ISNULL:"QName"

The tests use the long QName form.

It will not find nodes that are not supposed to have the attribute.
So there is also a type check generated ….

The above will find nodes for which cm:content is null and the node is of a type which could have cm:content. So if your property is linked to an aspect, it will only find nodes that do not have the property but have got the aspect applied.

Andy

Re: porperty : NULL or unavailable in Lucene search

pl_componize — Tue, 14 Feb 2012 10:24:35 GMT

Hi

You can use queries like ISNULL:"cm:name".

The performance may not be great, and could be improved, but it will work.

Andy

We have issues with ISNULL performance (org.apache.lucene.search.BooleanQuery$TooManyClauses), what suggestion do you have in this regard?

thank you

Re: porperty : NULL or unavailable in Lucene search

prignony — Thu, 17 Mar 2016 11:36:49 GMT

I've the same issue with Alfresco3. I know it is a old post but if someone have a solution.
I changed the query to use +@XXX:

it work but the +ISNULL and +ISNOTNULL should work but it is interpreted as an OR in all my terme. It should be an AND