# Can't get my head around the Query Language
**URL:** https://discuss.elastic.co/t/cant-get-my-head-around-the-query-language/36737
**Category:** Elasticsearch
**Created:** [December 9, 2015, 11:52am UTC](https://discuss.elastic.co/t/cant-get-my-head-around-the-query-language/36737 "2015-12-09T11:52:27Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@aidzan](https://discuss.elastic.co/u/aidzan)
#### Post date: [December 9, 2015, 11:52am UTC](https://discuss.elastic.co/t/cant-get-my-head-around-the-query-language/36737/1 "2015-12-09T11:52:27Z")
I am using Elasticsearch to store alerts from our alerting system for metrics. I have a requirement where I need to pull Count of alerts grouped by Gateway and Application
I have been able to pull the Count for Application using agg, which gave me the following:
{
"key" : "App\_num",
"doc\_count" : 15135
},
How can I also make this Key take into consideration my Gateway that these Applications are related to so that it gives me a total count of each Application per Gateway? I am using the following to get the above:
curl -XPOST 'localhost:9200/\_search?pretty' -d '
{
"aggs": {
"group\_by\_app": {
"terms": {
"field": "AppNum",
"size": 0
}
}
}
}'
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 5, 2017, 11:32pm UTC](https://discuss.elastic.co/t/cant-get-my-head-around-the-query-language/36737/2 "2017-07-05T23:32:19Z")