{"action":"created","issue":{"url":"https://api.github.com/repos/smarthomeNG/plugins/issues/93","repository_url":"https://api.github.com/repos/smarthomeNG/plugins","labels_url":"https://api.github.com/repos/smarthomeNG/plugins/issues/93/labels{/name}","comments_url":"https://api.github.com/repos/smarthomeNG/plugins/issues/93/comments","events_url":"https://api.github.com/repos/smarthomeNG/plugins/issues/93/events","html_url":"https://github.com/smarthomeNG/plugins/pull/93","id":271284092,"number":93,"title":"Database plugin: more aggregation function sum, count, val","user":{"login":"ohinckel","id":717217,"avatar_url":"https://avatars0.githubusercontent.com/u/717217?v=4","gravatar_id":"","url":"https://api.github.com/users/ohinckel","html_url":"https://github.com/ohinckel","followers_url":"https://api.github.com/users/ohinckel/followers","following_url":"https://api.github.com/users/ohinckel/following{/other_user}","gists_url":"https://api.github.com/users/ohinckel/gists{/gist_id}","starred_url":"https://api.github.com/users/ohinckel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ohinckel/subscriptions","organizations_url":"https://api.github.com/users/ohinckel/orgs","repos_url":"https://api.github.com/users/ohinckel/repos","events_url":"https://api.github.com/users/ohinckel/events{/privacy}","received_events_url":"https://api.github.com/users/ohinckel/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":7,"created_at":"2017-11-05T14:58:28Z","updated_at":"2017-11-08T20:08:27Z","closed_at":null,"author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/smarthomeNG/plugins/pulls/93","html_url":"https://github.com/smarthomeNG/plugins/pull/93","diff_url":"https://github.com/smarthomeNG/plugins/pull/93.diff","patch_url":"https://github.com/smarthomeNG/plugins/pull/93.patch"},"body":"This is the implementation for issue https://github.com/smarthomeNG/smarthome/issues/235 which includes new aggregation functions and introduce finalizer function.\r\n"},"comment":{"url":"https://api.github.com/repos/smarthomeNG/plugins/issues/comments/342943556","html_url":"https://github.com/smarthomeNG/plugins/pull/93#issuecomment-342943556","issue_url":"https://api.github.com/repos/smarthomeNG/plugins/issues/93","id":342943556,"user":{"login":"ohinckel","id":717217,"avatar_url":"https://avatars0.githubusercontent.com/u/717217?v=4","gravatar_id":"","url":"https://api.github.com/users/ohinckel","html_url":"https://github.com/ohinckel","followers_url":"https://api.github.com/users/ohinckel/followers","following_url":"https://api.github.com/users/ohinckel/following{/other_user}","gists_url":"https://api.github.com/users/ohinckel/gists{/gist_id}","starred_url":"https://api.github.com/users/ohinckel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ohinckel/subscriptions","organizations_url":"https://api.github.com/users/ohinckel/orgs","repos_url":"https://api.github.com/users/ohinckel/repos","events_url":"https://api.github.com/users/ohinckel/events{/privacy}","received_events_url":"https://api.github.com/users/ohinckel/received_events","type":"User","site_admin":false},"created_at":"2017-11-08T20:08:27Z","updated_at":"2017-11-08T20:08:27Z","author_association":"MEMBER","body":"The query returns more then $count item because:\r\n* +1 item because the query includes the last value before $start too (was requested in #63)\r\n* +1 item when the item's last update is between $start and $end to reflect recent item changes\r\n* +1 item when $end is not the last timestamp from query by copying last entry with $end as timestamp\r\n\r\nThis means that the result could include up to 3 more items than requested.\r\n"}}
{"actor":{"display_login":"ohinckel"}}