Is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-06-08 Thread Gharbi Mohamed
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of

Re: Is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-06-08 Thread S.L
I am not sure if that is doable , I think it needs to be taken care of at the indexing time. On Sun, Jun 8, 2014 at 4:55 PM, Gharbi Mohamed gharbi.mohamed.e...@gmail.com wrote: Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to

Is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-05-15 Thread gharbi mohamed
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of

is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-05-15 Thread Mohamed23
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of

is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-05-11 Thread Gharbi Mohamed
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of

Is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-05-11 Thread gharbi mohamed
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of

Is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-05-11 Thread gharbi mohamed
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of

Re: is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-05-11 Thread Walter Underwood
Do that at index time. Index a document that has the product, the child products, and the total price. Flatten your data to match what the search results will display. Solr is not a relational system, so don't design with normalized tables, joins, and calculated result columns. wunder On May

Re: is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-05-11 Thread Jack Krupansky
Are these really sub-products? It sounds like you have the same product from multiple vendors and just want to return the lowest cost vendor, with no actual calculation. Either way, there is no direct method for this calculation/selection in Solr. Sure, you can always code a custom query

Re: is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-05-11 Thread Mohamed23
Thanks jack for your response, Actually my use case is that the sub products are the different sizes and colors of the parent product. So in order to have the adequate price for my product in the current search i need to return the minimum price of the matching sub-products, in other words i need

Re: Is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-05-10 Thread Ahmet Arslan
Hi Gharbi, It looks like CollapsingQParserPlugin can do that? fq={!collapse field=parent_id min=price_field} https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=40509582 Ahmet On Sunday, May 11, 2014 5:29 AM, gharbi mohamed gharbi.mohamed.e...@gmail.com wrote: Hi, I am

Is it possible for solr to calculate and give back the price of a product based on its sub-products

2014-05-10 Thread gharbi mohamed
Hi, I am using Solr for searching magento products in my project, I want to know, is it possible for solr to calculate and give back the price of a product based on its sub-products(items); For instance, i have a product P1 and it is the parent of items m1, m2. i need to get the minimal price of