topic Re: Lucene boolean search is broken? in Alfresco Archive

Lucene boolean search is broken?

kbryd — Sat, 18 Apr 2009 09:38:11 GMT

HelloI have been struggling with following issue. I have a type with a boolean property:<type name="plcy:commission"> <title>Commission</title> <parent>cm:content</parent> <properties> <property name="plcy:commission_accounted"> <title&

Re: Lucene boolean search is broken?

loftux — Sat, 18 Apr 2009 18:29:12 GMT

Having TYPE criteria in you search seem superfluous since your property is only available to that specific type.
Also, AND and the + means the same thing (so in some of your samples queries you have doubled them), see http://wiki.alfresco.com/wiki/Search#Combined_Queries

Maybe using - (must nor match) if only false query works. Then you maybe need to search for TYPE as well, contrary to what I said int the beginning.

Re: Lucene boolean search is broken?

kbryd — Sun, 19 Apr 2009 10:02:24 GMT

Having TYPE criteria in you search seem superfluous since your property is only available to that specific type.
Also, AND and the + means the same thing (so in some of your samples queries you have doubled them), see http://wiki.alfresco.com/wiki/Search#Combined_Queries

Maybe using - (must nor match) if only false query works. Then you maybe need to search for TYPE as well, contrary to what I said int the beginning.

You are right about TYPE criteria, however it shouldn't change the result…

Here is a summary of my queries:

Search:   @plcy\:commission_accounted:true
Results 24 rows

(some of those 24 rows contained records with 'false' commission_accounted)

Search:   @plcy\:commission_accounted:false
Results 686 rows

Search:   not @plcy\:commission_accounted:false
Results 686 rows

Search:   -@plcy\:commission_accounted:false
Results 0 rows

Search:   +TYPE:"plcy:commission" AND -@plcy\:commission_accounted:false
Results 24 rows

So the question is still the same: how is it possible? And how to query for records with commission_accounted=true?

Re: Lucene boolean search is broken?

loftux — Sun, 19 Apr 2009 13:46:56 GMT

Only thing I can think of to try is
+TYPE:"plcy:commission" AND -@plcy\:commission_accounted:true
That should give you all the false ones.

But I agree, this should be doable with only @plcy\:commission_accounted:false, maybe someone else can step in here that has experience of boolean searches.

Re: Lucene boolean search is broken?

kbryd — Sun, 19 Apr 2009 17:08:08 GMT

Unfortunately it doesn't work…

Search: +TYPE:"plcy:commission" AND -@plcy\:commission_accounted:true
Results 0 rows

I will try to report proper bug report about it and in the meantime I will try to change that attribute from boolean to an integer…

Thanks for suggestions!
Karol

Re: Lucene boolean search is broken?

mrogers — Mon, 03 Aug 2009 10:37:59 GMT

I was working yesterday on very similar query which works correctly.

+TYPE:"rma:dispositionAction" +@rma\:dispositionEventsEligible:true
+TYPE:"rma:dispositionAction" +@rma\:dispositionEventsEligible:false

I've just run it on HEAD and it works, both for the true case and the false case.