{"action":"created","issue":{"url":"https://api.github.com/repos/agershun/alasql/issues/709","repository_url":"https://api.github.com/repos/agershun/alasql","labels_url":"https://api.github.com/repos/agershun/alasql/issues/709/labels{/name}","comments_url":"https://api.github.com/repos/agershun/alasql/issues/709/comments","events_url":"https://api.github.com/repos/agershun/alasql/issues/709/events","html_url":"https://github.com/agershun/alasql/issues/709","id":166182481,"number":709,"title":"Question about MIN() aggregator use","user":{"login":"agerard","id":4429800,"avatar_url":"https://avatars.githubusercontent.com/u/4429800?v=3","gravatar_id":"","url":"https://api.github.com/users/agerard","html_url":"https://github.com/agerard","followers_url":"https://api.github.com/users/agerard/followers","following_url":"https://api.github.com/users/agerard/following{/other_user}","gists_url":"https://api.github.com/users/agerard/gists{/gist_id}","starred_url":"https://api.github.com/users/agerard/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agerard/subscriptions","organizations_url":"https://api.github.com/users/agerard/orgs","repos_url":"https://api.github.com/users/agerard/repos","events_url":"https://api.github.com/users/agerard/events{/privacy}","received_events_url":"https://api.github.com/users/agerard/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/agershun/alasql/labels/Solved:%20Please%20test","name":"Solved: Please test","color":"0e8a16"}],"state":"open","locked":false,"assignee":{"login":"agershun","id":643040,"avatar_url":"https://avatars.githubusercontent.com/u/643040?v=3","gravatar_id":"","url":"https://api.github.com/users/agershun","html_url":"https://github.com/agershun","followers_url":"https://api.github.com/users/agershun/followers","following_url":"https://api.github.com/users/agershun/following{/other_user}","gists_url":"https://api.github.com/users/agershun/gists{/gist_id}","starred_url":"https://api.github.com/users/agershun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agershun/subscriptions","organizations_url":"https://api.github.com/users/agershun/orgs","repos_url":"https://api.github.com/users/agershun/repos","events_url":"https://api.github.com/users/agershun/events{/privacy}","received_events_url":"https://api.github.com/users/agershun/received_events","type":"User","site_admin":false},"assignees":[{"login":"agershun","id":643040,"avatar_url":"https://avatars.githubusercontent.com/u/643040?v=3","gravatar_id":"","url":"https://api.github.com/users/agershun","html_url":"https://github.com/agershun","followers_url":"https://api.github.com/users/agershun/followers","following_url":"https://api.github.com/users/agershun/following{/other_user}","gists_url":"https://api.github.com/users/agershun/gists{/gist_id}","starred_url":"https://api.github.com/users/agershun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/agershun/subscriptions","organizations_url":"https://api.github.com/users/agershun/orgs","repos_url":"https://api.github.com/users/agershun/repos","events_url":"https://api.github.com/users/agershun/events{/privacy}","received_events_url":"https://api.github.com/users/agershun/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/agershun/alasql/milestones/10","html_url":"https://github.com/agershun/alasql/milestones/The%20Long%20List","labels_url":"https://api.github.com/repos/agershun/alasql/milestones/10/labels","id":1497179,"number":10,"title":"The Long List","description":"The long list of good ideas - issues will be closed but reopend when its time has come. ","creator":{"login":"mathiasrw","id":1063454,"avatar_url":"https://avatars.githubusercontent.com/u/1063454?v=3","gravatar_id":"","url":"https://api.github.com/users/mathiasrw","html_url":"https://github.com/mathiasrw","followers_url":"https://api.github.com/users/mathiasrw/followers","following_url":"https://api.github.com/users/mathiasrw/following{/other_user}","gists_url":"https://api.github.com/users/mathiasrw/gists{/gist_id}","starred_url":"https://api.github.com/users/mathiasrw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mathiasrw/subscriptions","organizations_url":"https://api.github.com/users/mathiasrw/orgs","repos_url":"https://api.github.com/users/mathiasrw/repos","events_url":"https://api.github.com/users/mathiasrw/events{/privacy}","received_events_url":"https://api.github.com/users/mathiasrw/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":9,"state":"open","created_at":"2016-01-11T13:12:25Z","updated_at":"2016-07-26T20:27:12Z","due_on":null,"closed_at":null},"comments":10,"created_at":"2016-07-18T20:13:30Z","updated_at":"2016-07-27T10:46:22Z","closed_at":null,"body":"I've made huge progress with my proj. thanks to your help and library, and am in the home stretch (a slightly earlier version can be seen at http://beta.ciesin.columbia.edu/jbwq/) . But am having a problem with figuring out how to avoid 0 as the value returned from the MIN() aggregator for columns with null values(Nulls seem to be seen as 0,  but 0 isn't a useful minimum). What I think I'm really needing is \"LEAST()\" - i.e something that drops all nulls/0 values before aggregating. There are probably ways to make a custom function but I am really hoping not to have to do that at this point. My current workaround is to use MIN(IFNULL(' + selectedParam + ',10000)) so any nulls clearly won't be minimums...just wondering if there's a better way.\r\n"},"comment":{"url":"https://api.github.com/repos/agershun/alasql/issues/comments/235551194","html_url":"https://github.com/agershun/alasql/issues/709#issuecomment-235551194","issue_url":"https://api.github.com/repos/agershun/alasql/issues/709","id":235551194,"user":{"login":"mathiasrw","id":1063454,"avatar_url":"https://avatars.githubusercontent.com/u/1063454?v=3","gravatar_id":"","url":"https://api.github.com/users/mathiasrw","html_url":"https://github.com/mathiasrw","followers_url":"https://api.github.com/users/mathiasrw/followers","following_url":"https://api.github.com/users/mathiasrw/following{/other_user}","gists_url":"https://api.github.com/users/mathiasrw/gists{/gist_id}","starred_url":"https://api.github.com/users/mathiasrw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mathiasrw/subscriptions","organizations_url":"https://api.github.com/users/mathiasrw/orgs","repos_url":"https://api.github.com/users/mathiasrw/repos","events_url":"https://api.github.com/users/mathiasrw/events{/privacy}","received_events_url":"https://api.github.com/users/mathiasrw/received_events","type":"User","site_admin":false},"created_at":"2016-07-27T10:46:22Z","updated_at":"2016-07-27T10:46:22Z","body":"Hmm. What if you do a `' + chemString + ' != null` ?"}}
{"actor":{"display_login":"mathiasrw"}}