4

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>
2
  • 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, 2012 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, 2013 at 9:34

2 Answers 2

15

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>
1
  • I'm glad to help. :)
    – Alex Boev
    Feb 11, 2012 at 11:23
9

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

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.