Querying a simple list with a 'User' column, using CAML

Question

I'm having some trouble getting a CAML Query working against a very simple list.

My custom list has the fields:

• Person : User
• Date : Date
• Amount : Lookup

My query looks like this:

<Query>
  <Where>
    <Eq>
      <FieldRef Name='Person' LookupId='TRUE' />
      <Value Type='Integer'>{0}</Value>
    </Eq>
  </Where>
</Query>

and {0} contains an integer.

Problem

My list contains 8 elements, divided between two seperate users. My query is supposed to get me 4 elements back, but is always returning 8.

I have been researching this for quite some time now (using both U2U Query Builder, and trying to handwrite it) but have been unable to get it to filter.

Please advise!

Solution

The solution was to remove the <Query></Query> from the CAML Query-string. The below accepted answer doesn't adress this, though it is also correct.

Answer 1

Try to use this caml:

<Where>
  <Eq>
    <FieldRef Name="Author" LookupId="True" />
    <Value Type="User">123</Value>
  </Eq>
</Where>

this also might work, but first is preferable:

<Where>
  <Eq>
    <FieldRef Name="Author" LookupId="True" />
    <Value Type="Lookup">123</Value>
  </Eq>
</Where>

and also, if you want to pass current logged user into caml query, you can use this one:

<Where>
  <Eq>
    <FieldRef Name="Author" />
    <Value Type="Integer">
      <UserID />
    </Value>
  </Eq>
</Where>

Answer 2

if you are using the system account (probably in your development environment (Virtual Machine)), the does not work as expected.

The user Purna said the same thing in this post.