Anybody can explain how pagination in sharepoint caml query works? I
don't understand the few examples there is on the internet. Thanks.

Hi Cykill

When you're using the list web service method GetListItems and the result is limited by RowCount (either because you
specified it in the request or due to it being in the view that's used) then the rs:data element will contain both
ItemCount and ListItemCollectionPositionNext attributes like this:
<rs:data ItemCount="100" ListItemCollectionPositionNext="Paged=TRUE&amp;p_T itle=Test%20data&amp;p_ID=304">
... all the z:row elements
</rs:data>

When you want the next page you need to use the same query as before but with the ListItemCollectionPositionNext
attribute in a Paging element in QueryOptions like this:

<Paging ListItemCollectionPositionNext="Paged=TRUE&amp;p_T itle=Test%20data&amp;p_ID=304"/>

You then repeat this (changing the ListItemCollectionPositionNext for each call) until you get a rs-data with only
ItemCount like this:
<rs:data ItemCount="31">

On Tue, 10 Mar 2009 21:56:33 -0700, cykill <cykill> wrote:

Thanks for you reply. Does the p_Title field required? I'm trying to
get it to work with Paged=TRUE&p_ID=5 to work but it keeps returning all
the rows.



Per Jakobsen wrote:
[..]

Hi Cykill

You should NEVER hardcode or generate the ListItemCollectionPositionNext attribute yourself. It SHOULD always be take
from the previous response. The presense of p_Title in my example was due to the original query being sorted by Title
(but you shouldn't care how it's build).

But let's step back a bit:

GetListItems takes a lot of parameters:
public XmlNode GetListItems (string listName, string viewName, XmlNode query, XmlNode viewFields, string rowLimit,
XmlNode queryOptions, string webID)

To start using paging you need a rowLimit. This can be given by specifying a view which has a row limit, but it's better
to specify your paging size in the rowLimit parameter (it's a string like "25").

When you specify a rowLimit then you first request will only return that number of rows, but have the
ListItemCollectionPositionNext in rs:data for use in the request for the next page.


On Wed, 11 Mar 2009 15:17:48 -0700, Cykill <no> wrote:
[..]