I have three relevant DataTypes: User, Team and Contract.
I’m trying set the Privacy Data Roles for the Contract DataType so that a particular Contract is only visible to a User who is a member of a Team associated with that Contract (for example, Jane is in the HR Team, the HR team can see “Tom’s Employment Contract”, so Jane can see that Contract) .
I’m having trouble because it doesn’t seem possible in the Privacy Data Roles’ “When” setting to test whether the Current User’s Team (list - e.g. “HR, Finance”) intersects with the Contract’s Team (list - e.g. “HR”). It only seems possible to see if one list contains a particular item:
I want to make sure I get the Privacy Rules 100% correct. Has anyone come across this issue? Any suggested workarounds?