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>
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>
We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.