Filtering a List by AssignedTo for a User’s Groups

If you need to create a view which filters the AssignedTo field, you can set the filter to =[Me] in the user interface.  The user will see items assigned to himself or herself.

But what if the items are assigned to groups to which the user belongs, as well as to the user individually?

1. Create a new view, and open the view’s .aspx page in SharePoint Designer.
2. Locate the <ListViewXML> tag
3. Locate the Where clause inside the tag.  It begins with &lt;Where and ends with /Where&gt;.
4. Replace the tag with the following:
   
   &lt;Where&gt;&lt;Or&gt;&lt;Membership Type="CurrentUserGroups"&gt;&lt;FieldRef Name="AssignedTo"/&gt;&lt;/Membership&gt;&lt;Eq&gt;&lt;FieldRef Name="AssignedTo"/&gt;&lt;Value Type="Integer"&gt;&lt;UserID Type="Integer"/&gt;&lt;/Value&gt;&lt;/Eq&gt;&lt;/Or&gt;&lt;/Where&gt;