Filter People and Group column using [Me]

Question

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.

Answer 1

I think below link is what you are looking to achieve Click here!

Also please check out the technet article link in that post.

Hope this helps

Cheers!

Answer 2

Hope this will help you out

http://alottolearn.net/2011/11/28/filter-active-tasks-by-me-and-me-as-group-member/

here is how it would be done using the Membership Element in CAML:

<Query>
   <Where>
    <And>
     <Neq>
      <FieldRef Name="Status"/>
      <Value Type="Text">Completed</Value>
     </Neq>
     <Or>
      <Membership Type="CurrentUserGroups">
        <FieldRef Name="AssignedTo"/>
      </Membership>
      <Eq>
       <FieldRef Name="AssignedTo"/>
       <Value Type="Integer">
         <UserID Type="Integer"/>
       </Value>
      </Eq>
     </Or>
    </And>
   </Where>
</Query>