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 9, 2014, at 12:29 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 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 items and return it as a price of product > P1. > > I'm wondering if that is possible, can you help me ? > I need to know if solr can do that or if there is a feature or a way to do > it ? > And finally i thank you! > > regards, > Mohamed. >