How to set privacy rules on users where lists intersect?

[42.decaen]

Hi,

I’m looking to set privacy rules on Users. Each User has access to a list of Companies :

In the example above, I’d like Julia and Chris to be able to view each other because they both have access to Starbucks. I’d like Julia and Rebecca to be able to view each other because they both have access to Walmart. And I’d like Chris and John to be able to view each other because they both have access to Ford.

I can’t find any operator that would allow to check for an intersection of lists. What I would need is something like that: “When Julia’s list of companies intersects with Chris’ lists of companies, then allow them to view each other”

Any idea how to do that?

[TipLister]

you could create a new datatype with one row for every intersection that saves the users involved and display and put privacy rules on that

[42.decaen]

Thank you for your reply.
What do you mean by “and display”? Not sure I fully understand what you are suggesting.