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>

What do you mean "it didn't work"? Did you get an error? Were no results returned? What is the ID of the user you are searching for on the site? Where is this code running? — Kit Menke, Feb 10 '12 at 21:59
This is working like a charm, my only doubt when i used in u2u caml query tool no results cameup any clues? — user966391, Jun 15 '13 at 9:34

shobani · Accepted Answer · 2012-02-11 11:20:31Z

13

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>

answered Feb 11 '12 at 11:20

shobani

1811 gold badge2 silver badges9 bronze badges

Add a comment |

Alex Boev · Accepted Answer · 2012-02-10 21:59:24Z

2 Answers 2