Our list has a people and group column (called Users) which we want to filter using [Me]. It works when the field only contains individual users, but when the field contains a group (either SP group or AD group) then rows for which [Me] is a member of the group it fails to match.
Here is an example:
ID | Users
1 | John; Bill
2 | Accounting
3 | Engineering
Assuming that John is an engineer, I would expect the filter using [Me] (when John is using it) to return rows 1 and 3 (because John is part of the Engineering Active Directory group), but alas only row 1 is returned.
Is this behavior possible when declaring a view over this list? Or do I need to resort to a CAML query (example?), or even a web service which will interact with Active Directory to resolve John's membership in the Engineering and Accounting groups.