do you know if it's possible with CAML to write a SharePoint list view filter query to retrieve a user that is a member of a group which in turn is a member of another group i.e. nested groups?
I've got it working so that the column "Members" is filtered to show users that are members of a security group:
<Or> <Membership Type="CurrentUserGroups"> <FieldRef Name="Members" /> </Membership> <Eq> <FieldRef Name="Members" /> <Value Type="Integer"> <UserID/> </Value> </Eq> </Or>
This gives me the list items where the currently logged in user is a member of a security group in the "Members" list column.
However, I'm unable to get it to go down a level further. Use case is there're users that are members of a security group which itself is a member of another security group and that one is the actual value of a field in the "Members" list column.