Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

2 Answers

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!

share|improve this answer
    
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
add comment

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:

<Or>
  <Membership Type="CurrentUserGroups">
  <FieldRef Name="AssignedTo"/>
 </Membership>
 <Eq>
 <FieldRef Name="AssignedTo"/>
<Value Type="Integer">
  <UserID/>
</Value>
</Eq>
</Or>
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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