{"action":"opened","issue":{"url":"https://api.github.com/repos/eSpectrum-IT/brassica/issues/385","repository_url":"https://api.github.com/repos/eSpectrum-IT/brassica","labels_url":"https://api.github.com/repos/eSpectrum-IT/brassica/issues/385/labels{/name}","comments_url":"https://api.github.com/repos/eSpectrum-IT/brassica/issues/385/comments","events_url":"https://api.github.com/repos/eSpectrum-IT/brassica/issues/385/events","html_url":"https://github.com/eSpectrum-IT/brassica/issues/385","id":139017530,"number":385,"title":"A query to propagate privacy setting throughout the entire model","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":3,"closed_issues":0,"state":"open","created_at":"2016-03-07T15:54:38Z","updated_at":"2016-03-07T16:07:45Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2016-03-07T16:07:45Z","updated_at":"2016-03-07T16:07:45Z","closed_at":null,"body":"Provide a query (in a suitable form - probably not inside the model since it may touch most of the DB - it would be best to consult @kammerer where to put that query) that, given a PlantTrial id, a User id and a privacy flag value, makes all records in the entire model, that are somehow related to the given PlantTrial, and are owned by the given User, set as either public or private.\r\n\r\nYou'll need to carefully devise the **signal propagation algorithm**, that stems from a single PT object, that would not enter circles, but still reach all the relevant tables.\r\n\r\n"}}