- When a user is added an organisation is assigned to them
- Departments are also selected for them (list of departments)
- When an article is published it belongs to an organisation and it can be tagged (list of departments) so only users who belong to those departments can view the article.
- I have a privacy rule in the organisation, so only users who belong to that organisation can view that organisation’s articles
What is most efficient & secure way to allow users to view articles tagged with departments they belong to. At the moment I’m doing it with a search in a repeating group using “Intersects with”.
Ideally I want to do the search on the server side and also have a privacy rule in place for this (something like… Articles departments contains current users departments)