hi,
I want to get top 10 records from list using caml query with object model in sharepoint.
Thanks
(Visited 159 times, 1 visits today)
Sami,
I don’t think you need to pass whole query. Because ID will never be null. Just pass orderby clause and its done.
(Visited 1 times, 1 visits today)
Try something like this is the CAML query:
<Where><And><FieldRef Name=’ID’ /><IsNotNull><FieldRef Name=’ID’ /></IsNotNull></And></Where> <OrderBy><FieldRef Name=’Created’ Ascending=’False’ /></OrderBy>”;
(Visited 1 times, 1 visits today)
I Think this may work for you
SPQuery oQuery = new SPQuery();
oQuery.RowLimit = 10;
oQuery.Query = “<OrderBy><FieldRef Name=’ID’ Ascending=’False’ /></OrderBy>”;
SPListItemCollection oColl = SPList.GetItems(oQuery);
(Visited 1 times, 1 visits today)
Great. Would you like to share the current code, then?
(Visited 1 times, 1 visits today)
