CAML Query on “Person” field type

Question

I would like to query list and get items that were created by specific user, in my list I have the fild "User" of type Person

I tried this but it didn't work:

<Where>
 <Eq>
  <FieldRef Name='User' />
   <Value Type='Lookup'>1</Value>
 </Eq>
</Where>

Answer 1

Thanks Alex, that article helped!

What I was missing is "LookupId='TRUE'" in the tag should has , the following is the corrected query:

<Where>
 <Eq>
  <FieldRef Name='User' LookupId='TRUE' />
   <Value Type='Lookup'>1</Value>
 </Eq>
</Where>

Answer 2

http://www.stum.de/2008/02/06/querying-the-person-or-group-field-using-spquery/