Hi, Any clue? Thanks
-----Original Message----- From: Mikhail Ibraheem Sent: Sunday, April 30, 2017 10:09 AM To: solr-user@lucene.apache.org Subject: pagination of results of grouping by more than one field Hi, I have a problem that I need to group by X and Y and aggregator on Z and I need to paginate on the results. The results aren't flat they are in hierarchy so how to flat the results so we can paginate on them for each combination of X,Y like: Computers, Computer Laptops, 5.684790733920929E10 Computers, PE_Server, 1.1207993365851181E10 Computers, Monitors, 1.2723246848002455E9 Data Communications Hardware, Datacom Hardware, 6.3539691650598495E10 >From the sample of the results: "X":{ "buckets":[{ "val":"Computers", "count":981466, "Y":{ "buckets":[{ "val":"Computer Laptops", "count":391064, "sum":5.684790733920929E10}, { "val":"PE_Server", "count":218148, "sum":1.1207993365851181E10}, { "val":"Monitors", "count":122176, "sum":1.2723246848002455E9}]}}, { "val":"Data Communications Hardware", "count":428230, "Y":{ "buckets":[{ "val":"Datacom Hardware", "count":428230, "sum":6.3539691650598495E10}]}}, { "val":"Leasehold Improvements", "count":33677, "Y":{ "buckets":[{ "val":"Leasehold improvements", "count":33676, "sum":1.6308392462957385E12}, { "val":"Electrical & Air Conditioning", "count":1, "sum":4505.0}]}}, {