lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kydryavtsev Andrey <werde...@yandex.ru>
Subject Re: Help with a Join Query
Date Thu, 11 Dec 2014 18:40:35 GMT


11.12.2014, 21:24, "Darin Amos" <darincs@gmail.com>:
> Thanks,
>
> That looks like a viable option, I could do something like the following:
>
> q={!join from=parent to=id}<my main search term query>
> &fq={!join from=parent to=id}color:red
> &fq={!join from=parent to=id}color:blue
>
> With all these joins happening like this, what kind of performance concern is this? I
would guess this would start to cause a lot of work.
>
> Thanks
>
> Darin
>>  On Dec 11, 2014, at 1:04 PM, Kydryavtsev Andrey <werder06@yandex.ru> wrote:
>>
>>  How about something like
>>
>>  ({!join from=parent to=id}color:red) AND ({!join from=parent to=id}color:blue)
?
>>
>>  11.12.2014, 19:48, "Darin Amos" <darincs@gmail.com>:
>>>  Hello,
>>>
>>>  I am trying to execute a join query that I am not 100% sure how to execute.
Lets say I have a bunch of parent and child documents and every one of my child documents
has a single value field “color”.
>>>
>>>  If I want to search all parents that have a “red” child, tis is very easy:
>>>
>>>  {!join from=parent to=id}color:red
>>>
>>>  However, if I want to return only parents that have both a red AND a blue item
it gets tricky.
>>>
>>>  This query would return parents that have red OR blue
>>>  {!join from=parent to=id}color:red OR color:blue
>>>
>>>  And this query would return nothing since no child had both colors.
>>>  {!join from=parent to=id}color:red AND color:blue
>>>
>>>  Any suggestions? My thinking is I might require some kind of custom query.
>>>
>>>  Thanks!
>>>
>>>  Darin

Mime
View raw message