{"action":"created","issue":{"url":"https://api.github.com/repos/eSpectrum-IT/brassica/issues/384","repository_url":"https://api.github.com/repos/eSpectrum-IT/brassica","labels_url":"https://api.github.com/repos/eSpectrum-IT/brassica/issues/384/labels{/name}","comments_url":"https://api.github.com/repos/eSpectrum-IT/brassica/issues/384/comments","events_url":"https://api.github.com/repos/eSpectrum-IT/brassica/issues/384/events","html_url":"https://github.com/eSpectrum-IT/brassica/issues/384","id":139016151,"number":384,"title":"Make all Browse section tables privacy-aware","user":{"login":"Nuanda","id":107565,"avatar_url":"https://avatars.githubusercontent.com/u/107565?v=3","gravatar_id":"","url":"https://api.github.com/users/Nuanda","html_url":"https://github.com/Nuanda","followers_url":"https://api.github.com/users/Nuanda/followers","following_url":"https://api.github.com/users/Nuanda/following{/other_user}","gists_url":"https://api.github.com/users/Nuanda/gists{/gist_id}","starred_url":"https://api.github.com/users/Nuanda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Nuanda/subscriptions","organizations_url":"https://api.github.com/users/Nuanda/orgs","repos_url":"https://api.github.com/users/Nuanda/repos","events_url":"https://api.github.com/users/Nuanda/events{/privacy}","received_events_url":"https://api.github.com/users/Nuanda/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/eSpectrum-IT/brassica/labels/feature","name":"feature","color":"5319e7"}],"state":"open","locked":false,"assignee":{"login":"nowakowski","id":4568385,"avatar_url":"https://avatars.githubusercontent.com/u/4568385?v=3","gravatar_id":"","url":"https://api.github.com/users/nowakowski","html_url":"https://github.com/nowakowski","followers_url":"https://api.github.com/users/nowakowski/followers","following_url":"https://api.github.com/users/nowakowski/following{/other_user}","gists_url":"https://api.github.com/users/nowakowski/gists{/gist_id}","starred_url":"https://api.github.com/users/nowakowski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nowakowski/subscriptions","organizations_url":"https://api.github.com/users/nowakowski/orgs","repos_url":"https://api.github.com/users/nowakowski/repos","events_url":"https://api.github.com/users/nowakowski/events{/privacy}","received_events_url":"https://api.github.com/users/nowakowski/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/eSpectrum-IT/brassica/milestones/1","html_url":"https://github.com/eSpectrum-IT/brassica/milestones/E1.%20Data%20privacy%20management","labels_url":"https://api.github.com/repos/eSpectrum-IT/brassica/milestones/1/labels","id":1626656,"number":1,"title":"E1. Data privacy management","description":"Functionality number 1 from the BIP Extension design document (see the document for details).","creator":{"login":"Nuanda","id":107565,"avatar_url":"https://avatars.githubusercontent.com/u/107565?v=3","gravatar_id":"","url":"https://api.github.com/users/Nuanda","html_url":"https://github.com/Nuanda","followers_url":"https://api.github.com/users/Nuanda/followers","following_url":"https://api.github.com/users/Nuanda/following{/other_user}","gists_url":"https://api.github.com/users/Nuanda/gists{/gist_id}","starred_url":"https://api.github.com/users/Nuanda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Nuanda/subscriptions","organizations_url":"https://api.github.com/users/Nuanda/orgs","repos_url":"https://api.github.com/users/Nuanda/repos","events_url":"https://api.github.com/users/Nuanda/events{/privacy}","received_events_url":"https://api.github.com/users/Nuanda/received_events","type":"User","site_admin":false},"open_issues":9,"closed_issues":6,"state":"open","created_at":"2016-03-07T15:54:38Z","updated_at":"2016-03-30T20:31:23Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2016-03-07T16:01:52Z","updated_at":"2016-03-31T07:13:35Z","closed_at":null,"body":"This is a complex task - all datatables in the Browse section, in general case, should show only published data (if data ownership is not established - i.e. the user_id column is NULL, treat data as public).\r\n\r\nFor logged in users, the tables should also show private data (that is: **all owned data**, regardless the published flag value, and all **other data that is published**).\r\n\r\nPlease keep the generic model query mechanism established so far - since the problem at hand is generic for all tables, it should be doable to treat it that way in code as well.\r\n\r\nAlso consider joints - what happens in a view table, that draws a single column values from another database table, when the privacy settings differ."},"comment":{"url":"https://api.github.com/repos/eSpectrum-IT/brassica/issues/comments/203792174","html_url":"https://github.com/eSpectrum-IT/brassica/issues/384#issuecomment-203792174","issue_url":"https://api.github.com/repos/eSpectrum-IT/brassica/issues/384","id":203792174,"user":{"login":"nowakowski","id":4568385,"avatar_url":"https://avatars.githubusercontent.com/u/4568385?v=3","gravatar_id":"","url":"https://api.github.com/users/nowakowski","html_url":"https://github.com/nowakowski","followers_url":"https://api.github.com/users/nowakowski/followers","following_url":"https://api.github.com/users/nowakowski/following{/other_user}","gists_url":"https://api.github.com/users/nowakowski/gists{/gist_id}","starred_url":"https://api.github.com/users/nowakowski/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nowakowski/subscriptions","organizations_url":"https://api.github.com/users/nowakowski/orgs","repos_url":"https://api.github.com/users/nowakowski/repos","events_url":"https://api.github.com/users/nowakowski/events{/privacy}","received_events_url":"https://api.github.com/users/nowakowski/received_events","type":"User","site_admin":false},"created_at":"2016-03-31T07:13:35Z","updated_at":"2016-03-31T07:13:35Z","body":"It's in progress - cf. https://github.com/eSpectrum-IT/brassica/tree/privacy_aware_browsing\r\nI got sidetracked by other issues lately but I will continue to work on it over the coming 2 days."}}