topic Lucene ISNULL query in Alfresco Archive

Lucene ISNULL query

lista — Mon, 17 Feb 2014 23:38:52 GMT

Hi all,does anyone have any in-depth experience with this query?Basically, if you do a simple query on a repository that is not empty, it will fail miserably with the maxClauseCount error. I could go about setting it higher, but then it's just a matter of time before I hit it again.Let's imagine a q

Re: Lucene ISNULL query

mitpatoliya — Tue, 18 Feb 2014 06:30:57 GMT

I do not think cm:barCode is part of out of box content model. What you are trying to do with this query?
Your first part for query is also not correct as you should be using TYPE instead of aspect.
You need to narrow down to your custom content type in case you want to search within those contents only.

Re: Lucene ISNULL query

lista — Tue, 18 Feb 2014 08:34:44 GMT

I was simply typing those names from my head, for the sake of an example. The problem is in the "barBode:*" part of query, which is obviously a part of how the the whole "ISNULL" part works.

Re: Lucene ISNULL query

lista — Tue, 18 Feb 2014 16:46:04 GMT

For anyone interested, I simply ended up doing a Lucene search without the problematic part, and checking for property existance on found nodes. Any other comments are still welcome.

Cheers!