6

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.

2

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!

  • Looks to be the solution. I will accept once I was able to reproduce the result. Thx! – Philipp Schmid Oct 18 '12 at 0:20
1

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>

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.