Get user url using CAML request

Question

I am using CAML Query to filter entries from a list in a DataTable. I have an SPUser field on my list.

I am trying to get the user id of each user in a CAML request. Any ideas on how to achieve this?

Answer 1

Get Items for SPUser.ID:

<Where><Eq><FieldRef Name='Person' LookupId='TRUE'/><Value Type='Integer'>45</Value></Eq></Where>

Get items for current user:

<Where><Eq><FieldRef Name='Person' LookupId='TRUE'/><Value Type='Integer'><UserID/></Value></Eq></Where>

Get the items for the display username (which is usually displayed in the list):

<Where><Eq><FieldRef Name='Person'/><Value Type='Text'>Lastname, Raghu</Value></Eq></Where>