SharePoint: How to get Top 5 records by using CAML query from a list

camlsharepoint

I have already created a webpart to show the data from list, but I really want is to only show top 5 records from that list (by using CAML query).

Does anyone know how to do this? Many thanks.

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

Best Answer

You could set the RowLimit property of your SPQuery object.

The <RowLimit> tag is in the schema definition of a view (direct child of <View>) and therefore cannot be nested inside a <Query> tag.

Related Solutions

Sharepoint Lists – GroupBy

I ran the following query and seems to be working fine for me.

<Query>
   <GroupBy collapse="true">
      <FieldRef Name='Date' />
   </GroupBy>
   <OrderBy>
      <FieldRef Name='Title' />
   </OrderBy>
</Query>

I suggest you use the U2U CAML Query Builder tool to build and test your query's

R – How to filter list using CAML query from a custom search field

I recently posted two articles (part 1 | part 2) with very similar solution done with JavaScript. It allows you to do "search as you type" over a single list.

It is not exactly the thing you are looking for but it might help.

Best Answer

Related Solutions

Sharepoint Lists – GroupBy

R – How to filter list using CAML query from a custom search field

Related Topic