{"action":"opened","issue":{"url":"https://api.github.com/repos/scolby33/OCSPdash/issues/8","repository_url":"https://api.github.com/repos/scolby33/OCSPdash","labels_url":"https://api.github.com/repos/scolby33/OCSPdash/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/scolby33/OCSPdash/issues/8/comments","events_url":"https://api.github.com/repos/scolby33/OCSPdash/issues/8/events","html_url":"https://github.com/scolby33/OCSPdash/issues/8","id":251832063,"number":8,"title":"get_all_locations_with_test_results","user":{"login":"scolby33","id":9711846,"avatar_url":"https://avatars3.githubusercontent.com/u/9711846?v=4","gravatar_id":"","url":"https://api.github.com/users/scolby33","html_url":"https://github.com/scolby33","followers_url":"https://api.github.com/users/scolby33/followers","following_url":"https://api.github.com/users/scolby33/following{/other_user}","gists_url":"https://api.github.com/users/scolby33/gists{/gist_id}","starred_url":"https://api.github.com/users/scolby33/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/scolby33/subscriptions","organizations_url":"https://api.github.com/users/scolby33/orgs","repos_url":"https://api.github.com/users/scolby33/repos","events_url":"https://api.github.com/users/scolby33/events{/privacy}","received_events_url":"https://api.github.com/users/scolby33/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"cthoyt","id":5069736,"avatar_url":"https://avatars0.githubusercontent.com/u/5069736?v=4","gravatar_id":"","url":"https://api.github.com/users/cthoyt","html_url":"https://github.com/cthoyt","followers_url":"https://api.github.com/users/cthoyt/followers","following_url":"https://api.github.com/users/cthoyt/following{/other_user}","gists_url":"https://api.github.com/users/cthoyt/gists{/gist_id}","starred_url":"https://api.github.com/users/cthoyt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cthoyt/subscriptions","organizations_url":"https://api.github.com/users/cthoyt/orgs","repos_url":"https://api.github.com/users/cthoyt/repos","events_url":"https://api.github.com/users/cthoyt/events{/privacy}","received_events_url":"https://api.github.com/users/cthoyt/received_events","type":"User","site_admin":false},"assignees":[{"login":"cthoyt","id":5069736,"avatar_url":"https://avatars0.githubusercontent.com/u/5069736?v=4","gravatar_id":"","url":"https://api.github.com/users/cthoyt","html_url":"https://github.com/cthoyt","followers_url":"https://api.github.com/users/cthoyt/followers","following_url":"https://api.github.com/users/cthoyt/following{/other_user}","gists_url":"https://api.github.com/users/cthoyt/gists{/gist_id}","starred_url":"https://api.github.com/users/cthoyt/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cthoyt/subscriptions","organizations_url":"https://api.github.com/users/cthoyt/orgs","repos_url":"https://api.github.com/users/cthoyt/repos","events_url":"https://api.github.com/users/cthoyt/events{/privacy}","received_events_url":"https://api.github.com/users/cthoyt/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2017-08-22T04:03:02Z","updated_at":"2017-08-22T04:03:02Z","closed_at":null,"body":"I don't know how to make the SQL query such that it only returns `User` objects if they have at least one associates `Result` object.\r\n\r\nSee [here](https://github.com/scolby33/OCSPdash/blob/c9801d21b1bb97698f4acd67869f74c17571138f/src/ocspdash/web/manager.py#L206)."}}
{"actor":{"display_login":"scolby33"}}