I was to comment the very same solution! I think this will satisfy the user requirement. Thanks Antonio!
Cheers 2015-07-13 12:22 GMT+01:00 Antonio David Pérez Morales < adperezmora...@gmail.com>: > Hi again Yusnel > > Just to confirm, I have tested your use case and the query which returns > what you need is this one: > > http://localhost:8983/solr/category/select?q={!join from=categoryId > fromIndex=product to=id}*:*&wt=json&indent=true&fq=name:clothes&hl=false > > Please, check and let us know if it works for you > > Regards > > 2015-07-12 17:02 GMT+02:00 Antonio David Pérez Morales < > adperezmora...@gmail.com>: > > > Hi Yusnel > > > > I think the query is invalid. It should be "q=clothes&fq={!join > > from=type_id to=id fromIndex=products}" or "q=*:*&fq={!join from=type_id > > to=id fromIndex=products}clothes" as long as you are using an edismax > > parser or df param for default field, where "clothes" query is matched > to. > > > > Regards > > > > > > > > 2015-07-11 2:23 GMT+02:00 Yusnel Rojas García <yroj...@gmail.com>: > > > >> I have 2 indexes > >> > >> products { > >> id, > >> name, > >> type_id > >> .. > >> } > >> > >> and > >> > >> categories { > >> id, > >> name > >> .. > >> } > >> > >> and I want to get all categories that match a name and have products in > >> it. > >> my best guess would be: > >> > >> > http://localhost:8983/solr/categories/select?q=clothes&fl=*,score&fq={!join > >> from=type_id > >> < > http://localhost:8983/solr/categories/select?q=clothes&fl=*,score&fq=%7B!joinfrom=type_id > > > >> to=id fromIndex=products}*:* > >> > >> but always get an empty response. help please! > >> > >> Is a better way of doing that without using another index? > >> > > > > > -- -------------------------- Benedetti Alessandro Visiting card - http://about.me/alessandro_benedetti Blog - http://alexbenedetti.blogspot.co.uk "Tyger, tyger burning bright In the forests of the night, What immortal hand or eye Could frame thy fearful symmetry?" William Blake - Songs of Experience -1794 England
