{"action":"created","issue":{"url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/2113","repository_url":"https://api.github.com/repos/elastic/elasticsearch-net","labels_url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/2113/labels{/name}","comments_url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/2113/comments","events_url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/2113/events","html_url":"https://github.com/elastic/elasticsearch-net/issues/2113","id":157210558,"number":2113,"title":"How to get group by sum in Elastic search (Nest Client C#) with Where Condition","user":{"login":"imdineshk80","id":11956464,"avatar_url":"https://avatars.githubusercontent.com/u/11956464?v=3","gravatar_id":"","url":"https://api.github.com/users/imdineshk80","html_url":"https://github.com/imdineshk80","followers_url":"https://api.github.com/users/imdineshk80/followers","following_url":"https://api.github.com/users/imdineshk80/following{/other_user}","gists_url":"https://api.github.com/users/imdineshk80/gists{/gist_id}","starred_url":"https://api.github.com/users/imdineshk80/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/imdineshk80/subscriptions","organizations_url":"https://api.github.com/users/imdineshk80/orgs","repos_url":"https://api.github.com/users/imdineshk80/repos","events_url":"https://api.github.com/users/imdineshk80/events{/privacy}","received_events_url":"https://api.github.com/users/imdineshk80/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-27T13:47:27Z","updated_at":"2016-05-29T23:50:25Z","closed_at":"2016-05-29T23:50:24Z","body":"Have a nice day!\r\n\r\nThe following query needs to be translated into equivalent NEST query, please help \r\n`{\r\n  \"size\": 0,\r\n   \"query\" : {\r\n      \"constant_score\" : { \r\n         \"filter\" : {\r\n            \"bool\" : {\r\n              \"must\" : [\r\n                 {\"term\" : {\"Cycle\" : \"477\"}},\r\n                 {\"term\" : {\"year\" : 2016}},\r\n                 {\"term\" : {\"Code\" : \"20\"}}\r\n              ],\r\n              \"should\" : [\r\n                {\"terms\" : {\"type\" : [\"Q1\", \"Q2\", \"Q3\", \"Q4\"] }}   \r\n              ]\r\n           }\r\n         }\r\n      }\r\n   },\r\n  \"aggs\": {\r\n    \"group_by_clientId\": {\r\n      \"terms\": {\r\n        \"field\": \"clientId\",\r\n        \"size\": 100        \r\n      },\r\n      \"aggs\": {\r\n        \"sum_amount\": {\r\n          \"sum\": {\r\n            \"field\": \"amount\"\r\n          }\r\n        }\r\n      }\r\n    }\r\n  }\r\n}"},"comment":{"url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/comments/222390022","html_url":"https://github.com/elastic/elasticsearch-net/issues/2113#issuecomment-222390022","issue_url":"https://api.github.com/repos/elastic/elasticsearch-net/issues/2113","id":222390022,"user":{"login":"russcam","id":208231,"avatar_url":"https://avatars.githubusercontent.com/u/208231?v=3","gravatar_id":"","url":"https://api.github.com/users/russcam","html_url":"https://github.com/russcam","followers_url":"https://api.github.com/users/russcam/followers","following_url":"https://api.github.com/users/russcam/following{/other_user}","gists_url":"https://api.github.com/users/russcam/gists{/gist_id}","starred_url":"https://api.github.com/users/russcam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/russcam/subscriptions","organizations_url":"https://api.github.com/users/russcam/orgs","repos_url":"https://api.github.com/users/russcam/repos","events_url":"https://api.github.com/users/russcam/events{/privacy}","received_events_url":"https://api.github.com/users/russcam/received_events","type":"User","site_admin":false},"created_at":"2016-05-29T23:50:24Z","updated_at":"2016-05-29T23:50:24Z","body":"This question is best asked [in the discussion forums](https://discuss.elastic.co/c/elasticsearch) or [stackoverflow](http://stackoverflow.com/questions); Github issues are intended for issues and bugs with the client :smiley: "}}
{"actor":{"display_login":"russcam"}}