Elasticsearch - return document count by date - in date order

Question

I have the following to return a count of documents 'grouped' by the document date. However, I would like the results to be displayed in date order. I tried the 'sort' option but this doesn't seem to work.

Any suggestions ?

GET /my_index/my_type/_search
{
    size: 0,
    sort: {
        date: {
            order: "desc"   
        }
    },
    aggs: {
        "docs_by_date": {
            "terms": {
                "field": "date",
                "size": 0
            }
        }
    }
}

Richa · Accepted Answer · 2016-03-02 11:49:11Z

1

If you want to sort buckets use following query:

GET /my_index/my_type/_search
{
size: 0,

aggs: {
    "docs_by_date": {
        "terms": {
            "field": "date",
            "size": 0,
            "order" : { "_term" : "asc" }
        }
    }
   }
}

Read this for more info

answered Mar 2, 2016 at 11:49

Richa

7,6796 gold badges30 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Elasticsearch - return document count by date - in date order

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related