{"action":"created","issue":{"url":"https://api.github.com/repos/DoSomething/dosomething/issues/4607","labels_url":"https://api.github.com/repos/DoSomething/dosomething/issues/4607/labels{/name}","comments_url":"https://api.github.com/repos/DoSomething/dosomething/issues/4607/comments","events_url":"https://api.github.com/repos/DoSomething/dosomething/issues/4607/events","html_url":"https://github.com/DoSomething/dosomething/issues/4607","id":90431398,"number":4607,"title":"Output quantity JSON to hot phase module","user":{"login":"angaither","id":645205,"avatar_url":"https://avatars.githubusercontent.com/u/645205?v=3","gravatar_id":"","url":"https://api.github.com/users/angaither","html_url":"https://github.com/angaither","followers_url":"https://api.github.com/users/angaither/followers","following_url":"https://api.github.com/users/angaither/following{/other_user}","gists_url":"https://api.github.com/users/angaither/gists{/gist_id}","starred_url":"https://api.github.com/users/angaither/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/angaither/subscriptions","organizations_url":"https://api.github.com/users/angaither/orgs","repos_url":"https://api.github.com/users/angaither/repos","events_url":"https://api.github.com/users/angaither/events{/privacy}","received_events_url":"https://api.github.com/users/angaither/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/DoSomething/dosomething/labels/%23campaign-goals","name":"#campaign-goals","color":"bfdadc"},{"url":"https://api.github.com/repos/DoSomething/dosomething/labels/%23campaign-template","name":"#campaign-template","color":"bfdadc"}],"state":"open","locked":false,"assignee":{"login":"angaither","id":645205,"avatar_url":"https://avatars.githubusercontent.com/u/645205?v=3","gravatar_id":"","url":"https://api.github.com/users/angaither","html_url":"https://github.com/angaither","followers_url":"https://api.github.com/users/angaither/followers","following_url":"https://api.github.com/users/angaither/following{/other_user}","gists_url":"https://api.github.com/users/angaither/gists{/gist_id}","starred_url":"https://api.github.com/users/angaither/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/angaither/subscriptions","organizations_url":"https://api.github.com/users/angaither/orgs","repos_url":"https://api.github.com/users/angaither/repos","events_url":"https://api.github.com/users/angaither/events{/privacy}","received_events_url":"https://api.github.com/users/angaither/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/DoSomething/dosomething/milestones/25","html_url":"https://github.com/DoSomething/dosomething/milestones/Hot%20Module","labels_url":"https://api.github.com/repos/DoSomething/dosomething/milestones/25/labels","id":1095461,"number":25,"title":"Hot Module","description":"This milestone will encapsulate all work having to do with building and testing the \"Hot Module\" on the campaign template.   ","creator":{"login":"sbsmith86","id":1700409,"avatar_url":"https://avatars.githubusercontent.com/u/1700409?v=3","gravatar_id":"","url":"https://api.github.com/users/sbsmith86","html_url":"https://github.com/sbsmith86","followers_url":"https://api.github.com/users/sbsmith86/followers","following_url":"https://api.github.com/users/sbsmith86/following{/other_user}","gists_url":"https://api.github.com/users/sbsmith86/gists{/gist_id}","starred_url":"https://api.github.com/users/sbsmith86/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sbsmith86/subscriptions","organizations_url":"https://api.github.com/users/sbsmith86/orgs","repos_url":"https://api.github.com/users/sbsmith86/repos","events_url":"https://api.github.com/users/sbsmith86/events{/privacy}","received_events_url":"https://api.github.com/users/sbsmith86/received_events","type":"User","site_admin":false},"open_issues":10,"closed_issues":14,"state":"open","created_at":"2015-05-04T17:28:24Z","updated_at":"2015-06-29T19:37:49Z","due_on":"2015-08-01T04:00:00Z","closed_at":null},"comments":8,"created_at":"2015-06-23T16:22:45Z","updated_at":"2015-06-30T14:09:30Z","closed_at":null,"body":"return a json object to the campagin in hot module phases with the quantity total for each day\r\n\r\n```\r\nselect quanity \r\nfrom dosomething_quanity_log\r\nwhere nid = X\r\ngroup timestamp by dates\r\nand n.timestamp is max where timestamps \r\n```"},"comment":{"url":"https://api.github.com/repos/DoSomething/dosomething/issues/comments/117200354","html_url":"https://github.com/DoSomething/dosomething/issues/4607#issuecomment-117200354","issue_url":"https://api.github.com/repos/DoSomething/dosomething/issues/4607","id":117200354,"user":{"login":"sbsmith86","id":1700409,"avatar_url":"https://avatars.githubusercontent.com/u/1700409?v=3","gravatar_id":"","url":"https://api.github.com/users/sbsmith86","html_url":"https://github.com/sbsmith86","followers_url":"https://api.github.com/users/sbsmith86/followers","following_url":"https://api.github.com/users/sbsmith86/following{/other_user}","gists_url":"https://api.github.com/users/sbsmith86/gists{/gist_id}","starred_url":"https://api.github.com/users/sbsmith86/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sbsmith86/subscriptions","organizations_url":"https://api.github.com/users/sbsmith86/orgs","repos_url":"https://api.github.com/users/sbsmith86/repos","events_url":"https://api.github.com/users/sbsmith86/events{/privacy}","received_events_url":"https://api.github.com/users/sbsmith86/received_events","type":"User","site_admin":false},"created_at":"2015-06-30T14:09:30Z","updated_at":"2015-06-30T14:09:30Z","body":"@mikefantini Ah yea, lets sync. You are right and I think I confused things talking about aggregating stuff. But regardless, I definitely need data about those four dates, so there will be some logic around figuring out those dates programmatically, either on the backend or the frontend. "}}