Got puzzled now! If instead of AND I use &, it works:
fq = {!join from=root_id to=id}type:leg & {!join from=root_id to=id}type:arm
I am definitly missing something, I don't know what... Shouldn't both be
the same?
[]s
2013/7/10 Marcelo Elias Del Valle <mvall...@gmail.com>
> Dominique,
> I tried also:
> fq = {!join from=root_id to=id}type:leg AND {!join from=root_id
> to=id}type:arm
> If I understood what you said correctly, that should return something too,
> right? It also got me 0 results...
>
>
> 2013/7/10 Dominique Debailleux <dominique.debaill...@woana.net>
>
>> Sorry, I didn't check precisely....I guess in your sample &attr1 applies
>> to
>> the body, not the legs, that could explain your problem
>>
>>
>> 2013/7/10 Marcelo Elias Del Valle <mvall...@gmail.com>
>>
>> > This
>> > fq = {!join from=root_id to=id}type:leg&attr1=right OR {!join
>> from=root_id
>> > to=id}type:arm&attr1=left
>> > works even if I have attr1=left1 in the second condition. My goal is to
>> > select bodies that matches both conditions.
>> >
>> > It's strange, but if I try
>> > fq = {!join from=root_id to=id}type:leg&attr1=right AND {!join
>> from=root_id
>> > to=id}type:arm&attr1=left
>> >
>> > it returns zero results, but the body exists. I am guessing it's trying
>> to
>> > query for childs which have type equals to both leg AND arm and attr1
>> > equals to both right AND left...
>> >
>> > Not sure...
>> >
>> >
>> >
>> > 2013/7/10 Dominique Debailleux <dominique.debaill...@woana.net>
>> >
>> > > try fq = {!join from=root_id to=id}type:leg&attr1=right OR {!join
>> > > from=root_id to=id}type:arm&attr1=left
>> > >
>> > > Dom
>> > >
>> > >
>> > > 2013/7/10 Marcelo Elias Del Valle <mvall...@gmail.com>
>> > >
>> > > > 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
>> > > >
>> > >
>> > >
>> > >
>> > > --
>> > > Dominique Debailleux
>> > > WoAnA - small.but.robust
>> > > [image: Accèder au profil LinkedIn de Dominique
>> > > Debailleux]<http://www.linkedin.com/in/dominiquedebailleux>
>> > >
>> >
>> >
>> >
>> > --
>> > Marcelo Elias Del Valle
>> > http://mvalle.com - @mvallebr
>> >
>>
>>
>>
>> --
>> Dominique Debailleux
>> WoAnA - small.but.robust
>> [image: Accèder au profil LinkedIn de Dominique
>> Debailleux]<http://www.linkedin.com/in/dominiquedebailleux>
>>
>
>
>
> --
> Marcelo Elias Del Valle
> http://mvalle.com - @mvallebr
>
--
Marcelo Elias Del Valle
http://mvalle.com - @mvallebr
