Hi Emir, Thanks for your suggestion. This should meet my current needs.
Regards, Edwin On 20 February 2017 at 18:22, Emir Arnautovic <emir.arnauto...@sematext.com> wrote: > Json facets also have subfacets: http://yonik.com/solr-subfacets/ (check > if something changed in version that you use) > > Emir > > > > On 20.02.2017 10:42, Zheng Lin Edwin Yeo wrote: > >> 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/ >>> >>> >>> > -- > Monitoring * Alerting * Anomaly Detection * Centralized Log Management > Solr & Elasticsearch Support * http://sematext.com/ > >
