Archive for February, 2010
Filtered Data View for my items and items of groups that I am a member
Posted by Jake in SharePoint on February 1, 2010
I found that I could create a view that filtered items for myself ([Me]) and for the groups that I was in, but not both through the View editor. By editing the group view in SharePoint Designer, I updated the CAML query to filter both groups and items “assigned to me” and it worked just dandy:
<Query>
<GroupBy Collapse=”FALSE” GroupLimit=”30″>
<FieldRef Name=”AssignedTo”/>
</GroupBy>
<OrderBy>
<FieldRef Name=”AssignedTo”/>
<FieldRef Name=”Status”/>
</OrderBy>
<Where>
<Or>
<Membership Type=”CurrentUserGroups”/>
<FieldRef Name=”AssignedTo”/>
</Membership/>
<Eq>
<FieldRef Name=”AssignedTo”/>
<Value Type=”Integer”>
<UserID Type=”Integer”/>
</Value>
</Eq>
</Or>
</Where>
</Query>