Sharepoint 2010 CAML Query Person Lookup

Question

I have a CAML query where I am trying to retrieve records based on the logged in users id.

The following query works on my dev & qa environments, but not in my production environment. There is data that exists that matches the user. I have also tested inside SP CAML Query Helper and again there is 0 results returned.

I have tried:

<Where>
  <Eq>
    <FieldRef Name='SharepointUser' LookupId='TRUE'/><Value Type='Integer'>37</Value>
  </Eq>
</Where>

<Where>
  <Eq>
    <FieldRef Name='SharepointUser' LookupId='TRUE'/><Value Type='User'>37</Value>
  </Eq>
</Where>

<Where>
  <Eq>
    <FieldRef Name='SharepointUser' LookupId='TRUE'/><Value Type='Lookup'>37</Value>
  </Eq>
</Where>

SharepointUser is of Type="User"

Is there some setting that I am missing that I need to set for Lookups to work appropriately?

Ondrej Tucny Ondrej Tucny · Accepted Answer · 2013-11-12T22:03:43

If you are looking for the current user's ID, you should use the <UserID/> CAML element, like this:

<Where>
  <Eq>
    <FieldRef Name="SharepointUser" LookupId="TRUE"/><UserID/>
  </Eq>
</Where>

Sharepoint 2010 CAML Query Person Lookup

1 Answers