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: