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>