Hi Emir, Thanks for your suggestion. But I'm not sure if this could work, as I'm using JSON Facet and not the normal faceting.
Regards, Edwin On 20 February 2017 at 17:24, Emir Arnautovic <emir.arnauto...@sematext.com> wrote: > Hi Edwin, > > I am also bit confused but, it seems to me that you could achieve what you > need with pivot faceting: https://cwiki.apache.org/confl > uence/display/solr/Faceting#Faceting-Pivot(DecisionTree)Faceting > > HTH, > Emir > > > > On 18.02.2017 08:46, Zheng Lin Edwin Yeo wrote: > >> Although I have nested documents in the schema, but if not looking for top >> 10 parents to facet on children. >> >> Currently, I'm only working on the information that is available in >> children. In my case, each line represents a transaction, and I'm doing >> the >> faceting based on these individual transaction. >> >> Regards, >> Edwin >> >> >> On 17 February 2017 at 22:10, Alexandre Rafalovitch <arafa...@gmail.com> >> wrote: >> >> Am I missing something or do you have nested documents in the schema? >>> >>> It reads like you looking for top 10 parents and then want to facet on >>> children. Is that right? >>> >>> Regards, >>> Alex >>> >>> On 17 Feb 2017 5:35 AM, "Zheng Lin Edwin Yeo" <edwinye...@gmail.com> >>> wrote: >>> >>> I'm looking at JSON facet for both of type:terms and type:range. >>> >>> For example, I may have 100 Items in my collections, and each item can >>> have >>> many transactions. But I'm only interested to look at the top 10 items >>> which has the highest transaction rate (ie the highest count) >>> >>> I'm doing a calculation of the total amount and average amount. However, >>> I >>> will only want the total amount and average amount to be calculated based >>> on the top 10 items which has the highest transaction rate, and not all >>> the >>> 100 items. >>> >>> For now, I need the additional query to get the top 10 items first, >>> before >>> I run the JSON Facet to get the total amount and average amount for that >>> 10 >>> items. >>> >>> Regards, >>> Edwin >>> >>> >>> On 17 February 2017 at 18:02, alessandro.benedetti <a.benede...@sease.io >>> > >>> wrote: >>> >>> I think we are missing something here ... >>>> You want to fetch the top 10 results for your query, and allow the user >>>> >>> to >>> >>>> navigate only those 10 results through facets ? >>>> >>>> Which facets are you interested in ? >>>> Field facets ? >>>> Whatever facet you want, calculating it in your client, on 10 results >>>> shouldn't be that problematic. >>>> Are we missing something ? Why you would need an additional query ? >>>> >>>> Cheers >>>> >>>> >>>> >>>> ----- >>>> --------------- >>>> Alessandro Benedetti >>>> Search Consultant, R&D Software Engineer, Director >>>> Sease Ltd. - www.sease.io >>>> -- >>>> View this message in context: http://lucene.472066.n3. >>>> nabble.com/Select-TOP-10-items-from-Solr-Query-tp4320863p4320910.html >>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>> >>>> > -- > Monitoring * Alerting * Anomaly Detection * Centralized Log Management > Solr & Elasticsearch Support * http://sematext.com/ > >