SPQuery for my tasks

2013-05-16

Developing solution with multiple languages (or a language which is not English) sometimes can be a bit painful. To configure a Webpart to display only my tasks, I would filter for [Me] or [Ich].

To achieve the same via code / CAML, you can filter by UserID and not the string “Me”.

  1: <Where>

  2:   <Eq>

  3:     <FieldRef Name="AssignedTo" />

  4:     <Value Type="Integer">

  5:       <UserID />

  6:     </Value>

  7:   </Eq>

  8: </Where>

  9: <OrderBy>

 10:   <FieldRef Name="Status" />

 11:   <FieldRef Name="Priority" />

 12: </OrderBy>

  This is just a reminder for me, so I can find the information more quickly. But maybe this is useful for some of you as well 🙂