Re: Trouble getting a solr join query done

2015-07-13 Thread Alessandro Benedetti
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 > wha

Re: Trouble getting a solr join query done

2015-07-13 Thread Antonio David Pérez Morales
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 wor

Re: Trouble getting a solr join query done

2015-07-12 Thread Antonio David Pérez Morales
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. Regar

Trouble getting a solr join query done

2015-07-10 Thread Yusnel Rojas García
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 to=