{"action":"created","issue":{"url":"https://api.github.com/repos/MattHirschfelt/Nest-Extended/issues/15","labels_url":"https://api.github.com/repos/MattHirschfelt/Nest-Extended/issues/15/labels{/name}","comments_url":"https://api.github.com/repos/MattHirschfelt/Nest-Extended/issues/15/comments","events_url":"https://api.github.com/repos/MattHirschfelt/Nest-Extended/issues/15/events","html_url":"https://github.com/MattHirschfelt/Nest-Extended/pull/15","id":91233982,"number":15,"title":"Add ORDER BY to nest data query","user":{"login":"amaiman","id":484106,"avatar_url":"https://avatars.githubusercontent.com/u/484106?v=3","gravatar_id":"","url":"https://api.github.com/users/amaiman","html_url":"https://github.com/amaiman","followers_url":"https://api.github.com/users/amaiman/followers","following_url":"https://api.github.com/users/amaiman/following{/other_user}","gists_url":"https://api.github.com/users/amaiman/gists{/gist_id}","starred_url":"https://api.github.com/users/amaiman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amaiman/subscriptions","organizations_url":"https://api.github.com/users/amaiman/orgs","repos_url":"https://api.github.com/users/amaiman/repos","events_url":"https://api.github.com/users/amaiman/events{/privacy}","received_events_url":"https://api.github.com/users/amaiman/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-06-26T12:04:39Z","updated_at":"2015-06-26T12:05:34Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/MattHirschfelt/Nest-Extended/pulls/15","html_url":"https://github.com/MattHirschfelt/Nest-Extended/pull/15","diff_url":"https://github.com/MattHirschfelt/Nest-Extended/pull/15.diff","patch_url":"https://github.com/MattHirschfelt/Nest-Extended/pull/15.patch"},"body":"Have the SQL query from the 'nest' table return data sorted by date/time to ensure that the graph renders correctly if date entries are out of order in the SQL database (can occur if entries are manually removed due to bad data received from one of the APIs.)\r\n\r\n**Before:**\r\n\r\n![screen shot 2015-06-26 at 7 55 14 am](https://cloud.githubusercontent.com/assets/484106/8376795/0a5fb334-1bd9-11e5-8667-6ec678d49b02.png)\r\n\r\n**After:**\r\n\r\n![screen shot 2015-06-26 at 7 57 26 am](https://cloud.githubusercontent.com/assets/484106/8376807/1c94445c-1bd9-11e5-9a1e-1acf85989169.png)\r\n"},"comment":{"url":"https://api.github.com/repos/MattHirschfelt/Nest-Extended/issues/comments/115656522","html_url":"https://github.com/MattHirschfelt/Nest-Extended/pull/15#issuecomment-115656522","issue_url":"https://api.github.com/repos/MattHirschfelt/Nest-Extended/issues/15","id":115656522,"user":{"login":"amaiman","id":484106,"avatar_url":"https://avatars.githubusercontent.com/u/484106?v=3","gravatar_id":"","url":"https://api.github.com/users/amaiman","html_url":"https://github.com/amaiman","followers_url":"https://api.github.com/users/amaiman/followers","following_url":"https://api.github.com/users/amaiman/following{/other_user}","gists_url":"https://api.github.com/users/amaiman/gists{/gist_id}","starred_url":"https://api.github.com/users/amaiman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/amaiman/subscriptions","organizations_url":"https://api.github.com/users/amaiman/orgs","repos_url":"https://api.github.com/users/amaiman/repos","events_url":"https://api.github.com/users/amaiman/events{/privacy}","received_events_url":"https://api.github.com/users/amaiman/received_events","type":"User","site_admin":false},"created_at":"2015-06-26T12:05:34Z","updated_at":"2015-06-26T12:05:34Z","body":"Related to this issue: https://github.com/MattHirschfelt/Nest-Extended/issues/13"}}