Fetch All fields from a people group field using Caml Query

Question

I have a SharePoint list which contains a people or group field where I want to fetch the Id which is stored internally and name is displayed.

Can anyone tell me how to fetch all the values from person or group field using a CAML query?

It would be a great help.

Thanks in advance!!

Answer 1

To fetch the Values in person or group field you can use CAML as given below:

<View><ViewFields><FieldRef Name="PersonFieldName"/></ViewFields></View>

To Query/Filter for particular user on person or group field you can use anyone of below solutions:

<Where>
  <Eq>
    <FieldRef Name="PersonFieldName"/>
    <Value Type="User">User Display Name</Value>
  </Eq>
</Where>

Or

<Where>
   <Eq>
      <FieldRef Name="PersonFieldName" />
      <Value Type="Integer">UserID</Value>
   </Eq>
</Where>

Or

<Where>
   <Eq>
     <FieldRef Name="PersonFieldName" LookupId="TRUE"/>
     <Value Type="int">UserID</Value>
   </eq>
 </Where>

You can also use <UserID/> to get the Id which contains:

Contains the unique ID number of the currently authenticated user of a site, as defined in the UserInfo table of the content database.

Example:

<Where>
   <Eq>
      <FieldRef Name="PersonFieldName" />
      <Value Type="Integer">
         <UserID />
      </Value>
   </Eq>
</Where>

References:

1. ViewFields element (List).
2. Query schema.
3. UserID element (Query).