{"action":"created","issue":{"url":"https://api.github.com/repos/mulesoft/mongo-connector/issues/36","labels_url":"https://api.github.com/repos/mulesoft/mongo-connector/issues/36/labels{/name}","comments_url":"https://api.github.com/repos/mulesoft/mongo-connector/issues/36/comments","events_url":"https://api.github.com/repos/mulesoft/mongo-connector/issues/36/events","html_url":"https://github.com/mulesoft/mongo-connector/issues/36","id":22243669,"number":36,"title":"Aggregation Methods not supported","user":{"login":"cfedersp","id":284126,"avatar_url":"https://avatars.githubusercontent.com/u/284126?v=3","gravatar_id":"","url":"https://api.github.com/users/cfedersp","html_url":"https://github.com/cfedersp","followers_url":"https://api.github.com/users/cfedersp/followers","following_url":"https://api.github.com/users/cfedersp/following{/other_user}","gists_url":"https://api.github.com/users/cfedersp/gists{/gist_id}","starred_url":"https://api.github.com/users/cfedersp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cfedersp/subscriptions","organizations_url":"https://api.github.com/users/cfedersp/orgs","repos_url":"https://api.github.com/users/cfedersp/repos","events_url":"https://api.github.com/users/cfedersp/events{/privacy}","received_events_url":"https://api.github.com/users/cfedersp/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2013-11-07T04:16:45Z","updated_at":"2015-05-21T14:27:14Z","closed_at":"2015-05-21T14:27:14Z","body":"MongoDB has a powerful aggregation features that should be exposed to Mule users. \r\nHere is a draft list of 10 meaningful @Processors to expose by implementing combinations of MongoDB's Aggregation operators:\r\n\r\n1) Group -min\r\n2) Group -max\r\n3) Group -sum\r\n4) Group -average\r\n5) Sort\r\n6) Sort -Group-first\r\n7) Sort -Group-last\r\n8) GeoNear\r\n9) Project\r\n10) Project -unwind\r\n\r\nThe remaining operators, \"match\", \"skip\" and \"limit\" apply to all the above major operators and merely limit the domain the aggregators operate over.\r\n\r\nGroup Usage example:\r\nGiven a hypothetical collection of issues raised by users, \r\nTo count the number of different types of issues submitted by user \"1\", without knowing the different values for the various issueTypes ahead of time:\r\ndb.issues.aggregate(\r\n\t{$match: {\"userId\" : \"1\"}}, \r\n\t{$group : {_id : { userId:'$userId', issueType : '$issueType' },\r\n\t\tissuesFromUser : { $sum : 1 }\r\n\t}});\r\nReturns a result containing the userId, the issueType and the total number of rows that link that issueType to that user."},"comment":{"url":"https://api.github.com/repos/mulesoft/mongo-connector/issues/comments/104296676","html_url":"https://github.com/mulesoft/mongo-connector/issues/36#issuecomment-104296676","issue_url":"https://api.github.com/repos/mulesoft/mongo-connector/issues/36","id":104296676,"user":{"login":"cmartinezledo","id":10406699,"avatar_url":"https://avatars.githubusercontent.com/u/10406699?v=3","gravatar_id":"","url":"https://api.github.com/users/cmartinezledo","html_url":"https://github.com/cmartinezledo","followers_url":"https://api.github.com/users/cmartinezledo/followers","following_url":"https://api.github.com/users/cmartinezledo/following{/other_user}","gists_url":"https://api.github.com/users/cmartinezledo/gists{/gist_id}","starred_url":"https://api.github.com/users/cmartinezledo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cmartinezledo/subscriptions","organizations_url":"https://api.github.com/users/cmartinezledo/orgs","repos_url":"https://api.github.com/users/cmartinezledo/repos","events_url":"https://api.github.com/users/cmartinezledo/events{/privacy}","received_events_url":"https://api.github.com/users/cmartinezledo/received_events","type":"User","site_admin":false},"created_at":"2015-05-21T14:27:14Z","updated_at":"2015-05-21T14:27:14Z","body":"There is a Jira ticket created about this issue in order to implement this missing features.\r\n\r\nYou can follow this issue status here:  [Jira](https://www.mulesoft.org/jira/browse/CLDCONNECT-2323)"}}