gistfile1.txt

Query = 
GET /products/product/_search
{
  "query": { 
    "match_all" : {}
  },
  "aggs" : {
    "group_by_scode" : {
      "terms" : {
        "field" : "SCODE"
      }
    }
  }
}


Results = 
"hits" : …
 "aggregations": {
      "group_by_scode": {
         "buckets": [
            {
               "key": 1240069,
               "doc_count": 5
            }
         ]
      }
   }