Order elasticsearch aggregation

Question

I have multiple aggregations in my "query" see example. I use more aggregations sometimes. and I like to order the aggregations itself so "brand" is always on top of the aggregations list (in the result) and then "energy" for example?

If tried to figure it out myself but cant find anything that works.

{
    "size": 1000,
    "_source": ["id"],
    "query": { 
        "bool": { 
            "must": [
                { "match": { "category_default": "2" }}
            ],
            "must_not": [
                { "match": { "category_default": "2196" }},
                { "match": { "leverbaarheid_id": "3" }}
            ]
        }
    },  
    "aggs": {
        "brand": {
            "terms": {
                "field": "brand.keyword",
                "order": { "_term": "asc" }
            }
        },
        "min_price": { "min": { "field" : "selling_price" } },
        "max_price": { "max": { "field" : "selling_price" } },
        "energy": {
            "terms": {
                "field": "energy.keyword",
                "order": { "_term": "asc" }
            }
        }
    }
}

Do you want to order the aggregation results or aggregation buckets ? — TechnocratSid, Jul 07 '18 at 10:31
As a result I get the "aggregations" array back as [min_price, max_price, brand, energy] back. But i like to get it back like [brand, energy, min_price, max_price] Hope this makes sense — dingezzz, Jul 07 '18 at 10:39

score 1 · Accepted Answer · answered Jul 09 '18 at 16:33

I don't think this is directly possible.

I like to order the aggregations itself so "brand" is always on top of the aggregations list (in the result) and then "energy" for example?

Here you use name it "aggregations list" although it is actually a JSON object, which is the output format of Elasticsearch aggregations:

Each aggregation is associated with a logical name that the user defines ... . These logical names will also be used to uniquely identify the aggregations in the response.

Moreover, in a JSON object keys can be in any order, see for instance this question.

You would have to create a list from your aggregations with proper ordering on the client side.

Thanks! I just did this for the time being. But think this will be the final solution — dingezzz, Jul 10 '18 at 09:54

Order elasticsearch aggregation

1 Answers1