Elastic-search how to order by group values alphabetically?

Question

I have bellow query to group result, what i want to add to this query is to sort grouped values alphabetically.

GET promote_kmp/audit_table/_search
{
  "aggs":{
    "group_by_table_name":{
       "terms":{
         "field":"table_name",
         "size":1000000000
       }
    }
  }
}

Answer 1

Simply add the order setting:

POST promote_kmp/audit_table/_search
{
  "aggs":{
    "group_by_table_name":{
       "terms":{
         "field":"table_name",
         "size":1000000000,
         "order": { "_term": "asc" }          <---- add this
       }
    }
  }
}

Answer 2

Just add this:

GET promote_kmp/audit_table/_search
{
  "aggs":{
     "group_by_table_name":{
        "terms":{
           "field":"table_name",
           "size":1000000000,
           "order": {
             "_term": "asc"
           }
         }
       }
     }
   }