{"action":"created","issue":{"url":"https://api.github.com/repos/pixl8/Preside-CMS/issues/204","repository_url":"https://api.github.com/repos/pixl8/Preside-CMS","labels_url":"https://api.github.com/repos/pixl8/Preside-CMS/issues/204/labels{/name}","comments_url":"https://api.github.com/repos/pixl8/Preside-CMS/issues/204/comments","events_url":"https://api.github.com/repos/pixl8/Preside-CMS/issues/204/events","html_url":"https://github.com/pixl8/Preside-CMS/pull/204","id":185692948,"number":204,"title":"PRESIDECMS-611 Fix aggregate queries for Postgres","user":{"login":"sebduggan","id":208398,"avatar_url":"https://avatars.githubusercontent.com/u/208398?v=3","gravatar_id":"","url":"https://api.github.com/users/sebduggan","html_url":"https://github.com/sebduggan","followers_url":"https://api.github.com/users/sebduggan/followers","following_url":"https://api.github.com/users/sebduggan/following{/other_user}","gists_url":"https://api.github.com/users/sebduggan/gists{/gist_id}","starred_url":"https://api.github.com/users/sebduggan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sebduggan/subscriptions","organizations_url":"https://api.github.com/users/sebduggan/orgs","repos_url":"https://api.github.com/users/sebduggan/repos","events_url":"https://api.github.com/users/sebduggan/events{/privacy}","received_events_url":"https://api.github.com/users/sebduggan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-10-27T14:57:26Z","updated_at":"2016-11-15T10:45:59Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/pixl8/Preside-CMS/pulls/204","html_url":"https://github.com/pixl8/Preside-CMS/pull/204","diff_url":"https://github.com/pixl8/Preside-CMS/pull/204.diff","patch_url":"https://github.com/pixl8/Preside-CMS/pull/204.patch"},"body":"This fixes the issue for PostgreSQL by duplicating the group by logic from the MSSQL adapter.\n\nHowever, longer term it would be better to make explicit group by clauses part of the core, as it is also the default setting for MySQL 5.7 and later. And there might be a slightly neater way of handling it if it's baled in at a lower level...\n"},"comment":{"url":"https://api.github.com/repos/pixl8/Preside-CMS/issues/comments/260608945","html_url":"https://github.com/pixl8/Preside-CMS/pull/204#issuecomment-260608945","issue_url":"https://api.github.com/repos/pixl8/Preside-CMS/issues/204","id":260608945,"user":{"login":"DominicWatson","id":471162,"avatar_url":"https://avatars.githubusercontent.com/u/471162?v=3","gravatar_id":"","url":"https://api.github.com/users/DominicWatson","html_url":"https://github.com/DominicWatson","followers_url":"https://api.github.com/users/DominicWatson/followers","following_url":"https://api.github.com/users/DominicWatson/following{/other_user}","gists_url":"https://api.github.com/users/DominicWatson/gists{/gist_id}","starred_url":"https://api.github.com/users/DominicWatson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/DominicWatson/subscriptions","organizations_url":"https://api.github.com/users/DominicWatson/orgs","repos_url":"https://api.github.com/users/DominicWatson/repos","events_url":"https://api.github.com/users/DominicWatson/events{/privacy}","received_events_url":"https://api.github.com/users/DominicWatson/received_events","type":"User","site_admin":false},"created_at":"2016-11-15T10:45:59Z","updated_at":"2016-11-15T10:45:59Z","body":"This is great, thanks @sebduggan. Maybe you'll convert us to Postgres ;)"}}
{"actor":{"display_login":"DominicWatson"}}