{"action":"created","issue":{"url":"https://api.github.com/repos/publiclab/plots2/issues/3217","repository_url":"https://api.github.com/repos/publiclab/plots2","labels_url":"https://api.github.com/repos/publiclab/plots2/issues/3217/labels{/name}","comments_url":"https://api.github.com/repos/publiclab/plots2/issues/3217/comments","events_url":"https://api.github.com/repos/publiclab/plots2/issues/3217/events","html_url":"https://github.com/publiclab/plots2/pull/3217","id":348552465,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA2ODc2MzIz","number":3217,"title":"Improve peopleLocations endpoint: people_locations method","user":{"login":"milaaraujo","id":4355017,"node_id":"MDQ6VXNlcjQzNTUwMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/4355017?v=4","gravatar_id":"","url":"https://api.github.com/users/milaaraujo","html_url":"https://github.com/milaaraujo","followers_url":"https://api.github.com/users/milaaraujo/followers","following_url":"https://api.github.com/users/milaaraujo/following{/other_user}","gists_url":"https://api.github.com/users/milaaraujo/gists{/gist_id}","starred_url":"https://api.github.com/users/milaaraujo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/milaaraujo/subscriptions","organizations_url":"https://api.github.com/users/milaaraujo/orgs","repos_url":"https://api.github.com/users/milaaraujo/repos","events_url":"https://api.github.com/users/milaaraujo/events{/privacy}","received_events_url":"https://api.github.com/users/milaaraujo/received_events","type":"User","site_admin":false},"labels":[{"id":828958340,"node_id":"MDU6TGFiZWw4Mjg5NTgzNDA=","url":"https://api.github.com/repos/publiclab/plots2/labels/in%20progress","name":"in progress","color":"ededed","default":false},{"id":993990949,"node_id":"MDU6TGFiZWw5OTM5OTA5NDk=","url":"https://api.github.com/repos/publiclab/plots2/labels/rgsoc","name":"rgsoc","color":"f9d0c4","default":false},{"id":486046776,"node_id":"MDU6TGFiZWw0ODYwNDY3NzY=","url":"https://api.github.com/repos/publiclab/plots2/labels/summer-of-code","name":"summer-of-code","color":"5319e7","default":false}],"state":"open","locked":false,"assignee":{"login":"milaaraujo","id":4355017,"node_id":"MDQ6VXNlcjQzNTUwMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/4355017?v=4","gravatar_id":"","url":"https://api.github.com/users/milaaraujo","html_url":"https://github.com/milaaraujo","followers_url":"https://api.github.com/users/milaaraujo/followers","following_url":"https://api.github.com/users/milaaraujo/following{/other_user}","gists_url":"https://api.github.com/users/milaaraujo/gists{/gist_id}","starred_url":"https://api.github.com/users/milaaraujo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/milaaraujo/subscriptions","organizations_url":"https://api.github.com/users/milaaraujo/orgs","repos_url":"https://api.github.com/users/milaaraujo/repos","events_url":"https://api.github.com/users/milaaraujo/events{/privacy}","received_events_url":"https://api.github.com/users/milaaraujo/received_events","type":"User","site_admin":false},"assignees":[{"login":"milaaraujo","id":4355017,"node_id":"MDQ6VXNlcjQzNTUwMTc=","avatar_url":"https://avatars0.githubusercontent.com/u/4355017?v=4","gravatar_id":"","url":"https://api.github.com/users/milaaraujo","html_url":"https://github.com/milaaraujo","followers_url":"https://api.github.com/users/milaaraujo/followers","following_url":"https://api.github.com/users/milaaraujo/following{/other_user}","gists_url":"https://api.github.com/users/milaaraujo/gists{/gist_id}","starred_url":"https://api.github.com/users/milaaraujo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/milaaraujo/subscriptions","organizations_url":"https://api.github.com/users/milaaraujo/orgs","repos_url":"https://api.github.com/users/milaaraujo/repos","events_url":"https://api.github.com/users/milaaraujo/events{/privacy}","received_events_url":"https://api.github.com/users/milaaraujo/received_events","type":"User","site_admin":false},{"login":"stefannibrasil","id":10670581,"node_id":"MDQ6VXNlcjEwNjcwNTgx","avatar_url":"https://avatars3.githubusercontent.com/u/10670581?v=4","gravatar_id":"","url":"https://api.github.com/users/stefannibrasil","html_url":"https://github.com/stefannibrasil","followers_url":"https://api.github.com/users/stefannibrasil/followers","following_url":"https://api.github.com/users/stefannibrasil/following{/other_user}","gists_url":"https://api.github.com/users/stefannibrasil/gists{/gist_id}","starred_url":"https://api.github.com/users/stefannibrasil/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stefannibrasil/subscriptions","organizations_url":"https://api.github.com/users/stefannibrasil/orgs","repos_url":"https://api.github.com/users/stefannibrasil/repos","events_url":"https://api.github.com/users/stefannibrasil/events{/privacy}","received_events_url":"https://api.github.com/users/stefannibrasil/received_events","type":"User","site_admin":false}],"milestone":null,"comments":23,"created_at":"2018-08-08T02:31:00Z","updated_at":"2018-08-09T23:02:55Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/publiclab/plots2/pulls/3217","html_url":"https://github.com/publiclab/plots2/pull/3217","diff_url":"https://github.com/publiclab/plots2/pull/3217.diff","patch_url":"https://github.com/publiclab/plots2/pull/3217.patch"},"body":"Hey everybody!\r\n\r\nWe are opening this request to fix the issue #3196. Here we implemented a new version of `recentPeople` method. \r\n\r\nNow we first select the users that have lat/lon and then we join the users table with the revisions table to order them by most recent activities. We also change the name of the method from `recentPeople` to `people_locations`.\r\n\r\nWe would like some feedback, thanks! :)\r\n\r\nfixes #3196\r\n@publiclab/reviewers @publiclab/soc @jywarren"},"comment":{"url":"https://api.github.com/repos/publiclab/plots2/issues/comments/411925077","html_url":"https://github.com/publiclab/plots2/pull/3217#issuecomment-411925077","issue_url":"https://api.github.com/repos/publiclab/plots2/issues/3217","id":411925077,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMTkyNTA3Nw==","user":{"login":"jywarren","id":24359,"node_id":"MDQ6VXNlcjI0MzU5","avatar_url":"https://avatars1.githubusercontent.com/u/24359?v=4","gravatar_id":"","url":"https://api.github.com/users/jywarren","html_url":"https://github.com/jywarren","followers_url":"https://api.github.com/users/jywarren/followers","following_url":"https://api.github.com/users/jywarren/following{/other_user}","gists_url":"https://api.github.com/users/jywarren/gists{/gist_id}","starred_url":"https://api.github.com/users/jywarren/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jywarren/subscriptions","organizations_url":"https://api.github.com/users/jywarren/orgs","repos_url":"https://api.github.com/users/jywarren/repos","events_url":"https://api.github.com/users/jywarren/events{/privacy}","received_events_url":"https://api.github.com/users/jywarren/received_events","type":"User","site_admin":false},"created_at":"2018-08-09T23:02:55Z","updated_at":"2018-08-09T23:02:55Z","author_association":"CONTRIBUTOR","body":"maybe something like this... https://stackoverflow.com/questions/19548048/how-to-select-maxdate-and-group-by-client-id"}}
{"actor":{"display_login":"jywarren"}}