AnsweredAssumed Answered

Lucene ISNULL query

Question asked by lista on Feb 17, 2014
Latest reply on Feb 18, 2014 by lista
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 query along the lines of:


ASPECT:"cm:folder" AND ISNULL "cm:barCode"


If you look at what that query produces, you will see something like this:


+(ASPECT:{http://www.contentModel.com/model/content/1.0}folder) +(+MatchAllDocsQuery -(@{http://www.contentModel.com/model/content/1.0}barCode:* @{http://www.contentModel.com/model/content/1.0}barCode:{en}*))


So, it basically removes what it finds with the ISNULL part from the ASPECT part of the query, and since it tries to find all possible values for barCode, it hits the maxClauseCount.

Any way around this?

Thanks!

Outcomes