nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

porperty : NULL or unavailable in Lucene search

ajansen

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.

Find more posts tagged with

Comments

andy

Hi

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

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

Andy

putodemonio

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!!!! :? :?

andy

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

pl_componize

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

prignony

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