lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erick Erickson <erickerick...@gmail.com>
Subject Re: Two joins from different cores with OR
Date Fri, 15 Sep 2017 16:24:50 GMT
Two things:

1> The query language does not implement pure boolean logic, although
you can get that behavior with careful parenthesizing, see:
https://lucidworks.com/2011/12/28/why-not-and-or-and-not/

2> add &debug=query to the url and see how things are actually parsed
to try to chase down why you are getting the results you are.

Best,
Erick

On Fri, Sep 15, 2017 at 2:02 AM, Сергей Твердохлеб <selik.oo@gmail.com>
wrote:
> Hi all,
>
> I have two joins and I need to link them using OR statement.
>
> The first one is
>
>> fq={!join fromIndex=master_Category_flip from=manufactureName_string
>> to=nameString_string}visibility_string_mv:"Test_B2BUnit" AND
>> itemtype_string:"Model"
>
> which returns result A
>
> The second one is
>
>> fq=({!join fromIndex=master_Part_flip from=manufacturerNameFacet_string_mv
>> to=nameString_string}visibility_string_mv:"Test_B2BUnit")
>
>  which returns result B
>
> Using them like
>
>> fq=({!join fromIndex=master_Category_flip from=manufactureName_string
>> to=nameString_string}visibility_string_mv:"Test_B2BUnit" AND
>> itemtype_string:"Model") OR ({!join fromIndex=master_Part_flip
>> from=manufacturerNameFacet_string_mv
>> to=nameString_string}visibility_string_mv:"Test_B2BUnit")
>
>  It returns only result B
>
> Using it with AND instead of OR returns no result.
> Using 2 different fq statements also returns no results.
>
> With different data:
> First query returns A B C D
> Second query returns A B
> With OR returns only A B
> With AND returns no results
> With 2 fq's returns A B.
>
> Is there any way to get all results as I need?
> --
> Regards,
> Sergey Tverdokhleb

Mime
View raw message