I have a list with a "Person or Group" field that allows both people or groups.
Is it possible to have a CAML query that gets items where the current user is in that field? It would also have to check if the user is in a group that is in the field.
Say I have a security group called "team" with "user1" in it. And in the list I have an item where the field value is "user2; team". Then if "user2" or "user1" access the list they should see that item but "user3" should not.