Be careful with URL encoding... that may be messing you up depending
on how you are trying to submit the query (and the single & you were
using as AND)
fq={!join from=root_id to=id}type:arm AND attr1=left
fq={!join from=root_id to=id}type:leg AND attr1=right
-Yonik
http://lucidworks.com
On Wed, Jul 10, 2013 at 12:56 PM, Marcelo Elias Del Valle
<[email protected]> wrote:
> Hello,
>
> I am playing with joins here just to test what I can do with them. I
> have been learning a lot, but I am still having some troubles with more
> complex queries.
> For example, suppose I have the following documents:
>
>
> - id = 1 - name = Humblebee - age = 1000
> - id = 2 - type = arm - attr1 = left - size = 45 - unit = cm - root_id =
> 1
> - id = 3 - type = arm - attr1 = right - size = 46 - unit = cm - root_id
> = 1
> - id = 4 - type = leg - attr1 = left - size = 50 - unit = cm - root_id =
> 1
> - id = 5 - type = leg - attr1 = right - size = 52 - unit = cm - root_id
> = 1
>
> In my case, that would mean there is a body called humblebee with id 1
> and 4 child, each one a member of the body.
> What I am trying to do: select all bodies (root entities) that have a
> left arm and a right leg.
> To select the body based on the left arm, I would do:
>
> - q = *:*
> - fq = {!join from=root_id to=id}type:arm&attr1=left
>
> To select the body based on the right leg:
>
> - q = *:*
> - fq = {!join from=root_id to=id}type:leg&attr1=right
>
> But what if I need both left arm AND right leg? Should I do 2 joins?
>
> Best regards,
> --
> Marcelo Elias Del Valle
> http://mvalle.com - @mvallebr
