View Fields In CAML

The sample CAML Query using viewfields

SPQuery query = new SPQuery();
               query.Query = string.Concat(
                              "<Where><Eq>",                                 "<FieldRef Name='Status'/>",
                                 "<Value Type='CHOICE'>Not Started</Value>",
                              "</Eq></Where>",
                              "<OrderBy>",
                                 "<FieldRef Name='DueDate' Ascending='TRUE' />",
                                 "<FieldRef Name=’Priority’ Ascending='TRUE' />",
                              "</OrderBy>");                   

               query.ViewFields = string.Concat(
                                   "<FieldRef Name='AssignedTo' />",
                                   "<FieldRef Name='LinkTitle' />",
                                   "<FieldRef Name='DueDate' />",
                                   "<FieldRef Name='Priority' />");

               query.ViewFieldsOnly = true; // Fetch only the data that we need.

Determine Total Count Of Items Returned By SPQuery

 SPQuery query = new SPQuery();
   query.Query = string.Concat(
                  "<Where><Eq>",
                     "<FieldRef Name='Status'/>",
                     "<Value Type='CHOICE'>Not Started</Value>",
                  "</Eq></Where>",
                  "<OrderBy>",
                     "<FieldRef Name='DueDate' Ascending='TRUE' />",
                     "<FieldRef Name=’Priority’ Ascending='TRUE' />",
                  "</OrderBy>");                  


   SPListItemCollection items = list.GetItems(query);
   double totalCount = items.Count; 

Get Top 5 list items from Sharepoint List using CAML

Get Top 5 list items from Sharepoint List using CAML


This is a sample code for retrieving top 5 items from the SharePoint List.

SPQuery is the SharePoint class to initialize the CAML query.

This following Query will display the top 5 items OrderBy ID as Ascending is false.

SPQuery spQuery = new SPQuery();
spQuery.Query = "<Query>
   <OrderBy>
      <FieldRef Name='ID' Ascending='False' />
   </OrderBy> </Query> ";
spQuery.RowLimit = 5;