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}]}},

        {

 

Reply via email to