CAML query and Sharepoint Groups

Scenario:
Task list is one of the most commonly used list in sharepoint. But I think it is missing a view in which someone can filter what tasks are either directly assigned him or any of the Active Directory Group/SharePoint Group he belongs to.

Solution:
After some digging into CAML , I got the right CAML query for getting me exactly the same thing.

<Where>
<Or>
<Membership Type=”CurrentUserGroups”>
<FieldRef Name=”AssignedTo”/>
</Membership>
<Eq>
<FieldRef Name=”AssignedTo”></FieldRef>
<Value Type=”Integer”>
<UserID/>
</Value>
</Eq>
</Or>
</Where>
<OrderBy>
<FieldRef Name=”Status”/>
<FieldRef Name=”Priority”/>
</OrderBy>

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.