{"action":"created","issue":{"url":"https://api.github.com/repos/intermine/intermine/issues/640","repository_url":"https://api.github.com/repos/intermine/intermine","labels_url":"https://api.github.com/repos/intermine/intermine/issues/640/labels{/name}","comments_url":"https://api.github.com/repos/intermine/intermine/issues/640/comments","events_url":"https://api.github.com/repos/intermine/intermine/issues/640/events","html_url":"https://github.com/intermine/intermine/issues/640","id":32696642,"number":640,"title":"Queries - add aggregates e.g. MAX, count and AVG","user":{"login":"julie-sullivan","id":1663057,"avatar_url":"https://avatars1.githubusercontent.com/u/1663057?v=3","gravatar_id":"","url":"https://api.github.com/users/julie-sullivan","html_url":"https://github.com/julie-sullivan","followers_url":"https://api.github.com/users/julie-sullivan/followers","following_url":"https://api.github.com/users/julie-sullivan/following{/other_user}","gists_url":"https://api.github.com/users/julie-sullivan/gists{/gist_id}","starred_url":"https://api.github.com/users/julie-sullivan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/julie-sullivan/subscriptions","organizations_url":"https://api.github.com/users/julie-sullivan/orgs","repos_url":"https://api.github.com/users/julie-sullivan/repos","events_url":"https://api.github.com/users/julie-sullivan/events{/privacy}","received_events_url":"https://api.github.com/users/julie-sullivan/received_events","type":"User","site_admin":false},"labels":[{"id":15101641,"url":"https://api.github.com/repos/intermine/intermine/labels/enhancement","name":"enhancement","color":"02d7e1","default":true}],"state":"open","locked":false,"assignee":{"login":"justinccdev","id":12761716,"avatar_url":"https://avatars3.githubusercontent.com/u/12761716?v=3","gravatar_id":"","url":"https://api.github.com/users/justinccdev","html_url":"https://github.com/justinccdev","followers_url":"https://api.github.com/users/justinccdev/followers","following_url":"https://api.github.com/users/justinccdev/following{/other_user}","gists_url":"https://api.github.com/users/justinccdev/gists{/gist_id}","starred_url":"https://api.github.com/users/justinccdev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/justinccdev/subscriptions","organizations_url":"https://api.github.com/users/justinccdev/orgs","repos_url":"https://api.github.com/users/justinccdev/repos","events_url":"https://api.github.com/users/justinccdev/events{/privacy}","received_events_url":"https://api.github.com/users/justinccdev/received_events","type":"User","site_admin":false},"assignees":[{"login":"justinccdev","id":12761716,"avatar_url":"https://avatars3.githubusercontent.com/u/12761716?v=3","gravatar_id":"","url":"https://api.github.com/users/justinccdev","html_url":"https://github.com/justinccdev","followers_url":"https://api.github.com/users/justinccdev/followers","following_url":"https://api.github.com/users/justinccdev/following{/other_user}","gists_url":"https://api.github.com/users/justinccdev/gists{/gist_id}","starred_url":"https://api.github.com/users/justinccdev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/justinccdev/subscriptions","organizations_url":"https://api.github.com/users/justinccdev/orgs","repos_url":"https://api.github.com/users/justinccdev/repos","events_url":"https://api.github.com/users/justinccdev/events{/privacy}","received_events_url":"https://api.github.com/users/justinccdev/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/intermine/intermine/milestones/9","html_url":"https://github.com/intermine/intermine/milestone/9","labels_url":"https://api.github.com/repos/intermine/intermine/milestones/9/labels","id":558446,"number":9,"title":"Future InterMine release","description":"The release after the next release.","creator":{"login":"julie-sullivan","id":1663057,"avatar_url":"https://avatars1.githubusercontent.com/u/1663057?v=3","gravatar_id":"","url":"https://api.github.com/users/julie-sullivan","html_url":"https://github.com/julie-sullivan","followers_url":"https://api.github.com/users/julie-sullivan/followers","following_url":"https://api.github.com/users/julie-sullivan/following{/other_user}","gists_url":"https://api.github.com/users/julie-sullivan/gists{/gist_id}","starred_url":"https://api.github.com/users/julie-sullivan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/julie-sullivan/subscriptions","organizations_url":"https://api.github.com/users/julie-sullivan/orgs","repos_url":"https://api.github.com/users/julie-sullivan/repos","events_url":"https://api.github.com/users/julie-sullivan/events{/privacy}","received_events_url":"https://api.github.com/users/julie-sullivan/received_events","type":"User","site_admin":false},"open_issues":33,"closed_issues":6,"state":"open","created_at":"2014-02-04T13:39:12Z","updated_at":"2017-02-28T13:33:32Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2014-05-02T14:30:05Z","updated_at":"2017-03-22T12:36:52Z","closed_at":null,"body":"It would be nice to be able to use aggregates in queries, e.g. max, count and avg.\n"},"comment":{"url":"https://api.github.com/repos/intermine/intermine/issues/comments/288385468","html_url":"https://github.com/intermine/intermine/issues/640#issuecomment-288385468","issue_url":"https://api.github.com/repos/intermine/intermine/issues/640","id":288385468,"user":{"login":"julie-sullivan","id":1663057,"avatar_url":"https://avatars1.githubusercontent.com/u/1663057?v=3","gravatar_id":"","url":"https://api.github.com/users/julie-sullivan","html_url":"https://github.com/julie-sullivan","followers_url":"https://api.github.com/users/julie-sullivan/followers","following_url":"https://api.github.com/users/julie-sullivan/following{/other_user}","gists_url":"https://api.github.com/users/julie-sullivan/gists{/gist_id}","starred_url":"https://api.github.com/users/julie-sullivan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/julie-sullivan/subscriptions","organizations_url":"https://api.github.com/users/julie-sullivan/orgs","repos_url":"https://api.github.com/users/julie-sullivan/repos","events_url":"https://api.github.com/users/julie-sullivan/events{/privacy}","received_events_url":"https://api.github.com/users/julie-sullivan/received_events","type":"User","site_admin":false},"created_at":"2017-03-22T12:36:52Z","updated_at":"2017-03-22T12:36:52Z","body":"From @JoelRichardson \r\n\r\n```\r\n* specific aggregate functions:\r\n  - min, max, average, count\r\n  - others? (first, last, random choice, …)\r\n\r\n* include aggregate values in the results\r\n  - what are the min, max, and average lengths of all mouse Genes?\r\n\r\n* aggregates combined with simple constraints\r\n  - what are the min, max, and average lengths of all mouse Genes on\r\nchromosomes 1,12, and 14?\r\n\r\n* grouped aggregates (SQL group by clause)\r\n  - what are the min, max, and average lengths of all Genes grouped by\r\norganism and chromosome\r\n\r\n* sorting and aggregates (SQL order by applied to aggregates)\r\n  - what are the min, max, and average lengths of all Genes grouped by\r\norganism and chromosome. Sort by organsim, then by average gene length\r\n(descending)\r\n\r\n* aggregate contraints (SQL having clause)\r\n  - what are the min, max, and average lengths of all Genes grouped by\r\norganism and chromosome where the number of genes on the chromosome > 1500\r\n (not a very sensible query but...)\r\n```"}}
{"actor":{"display_login":"julie-sullivan"}}