Accessing last record in a sharepoint list via CAML query

Question

i ve some problem in accessing last record from sharepoint list through CAML query,can any one help me in this regrad;i have a sample list called 'MainHeads' which contains the information like HeadID,Category,and headName....

Mehboob Pakistan

score 5 · Answer 1 · answered Dec 08 '09 at 18:26

5

<View>
<RowLimit>1</RowLimit>
<Query>
   <OrderBy>
      <FieldRef Name='Created' Ascending='False' />
   </OrderBy>
</Query>
</View>

answered Dec 08 '09 at 18:26

Francisco Aquino

9,097
1
31
37

3

An alternative could be the ID Column, which (AFAIK) is also available on every item. – Michael Stum Feb 15 '10 at 12:59

score 3 · Answer 2 · edited Feb 17 '10 at 04:46

3

<View> 
<RowLimit>1</RowLimit> 
<Query> 
   <OrderBy> 
      <FieldRef Name='ID' Ascending='False' /> 
   </OrderBy> 
</Query> 
</View>

edited Feb 17 '10 at 04:46

Shoban

22,920
8
63
107

answered Feb 15 '10 at 12:56

Hojo

935
1
7
13

score 2 · Answer 3 · edited May 23 '17 at 11:46

Building on this answer I gave to a related question, I would suggest the following query:

SPListItem lastItem;

try
{
    using (SPSite objSite = new SPSite(sSiteUrl))
    {
        using (SPWeb objWeb = objSite.OpenWeb())
        {
            SPList objList = objWeb.Lists["MainHeads"];

            SPQuery objQuery = new SPQuery();
            objQuery.Query = "<OrderBy><FieldRef Name='HeadID' Ascending='False' /></OrderBy><RowLimit>1</RowLimit>";
            objQuery.Folder = objList.RootFolder;

            // Execute the query against the list
            SPListItemCollection colItems = objList.GetItems(objQuery);

            if (colItems.Count > 0)
            {
                lastItem = colItems[0];
            }
        }
    }
}
catch (Exception ex)
{
    ...
}

return lastItem;

This assumes that you are executing the CAML in code. IF not, see F. Aquino's answer.

Accessing last record in a sharepoint list via CAML query

3 Answers3