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
