Paging

Paging the results

There are a couple of query options that gives you control over your results and how they are ordered. With them you can not only able to create collection results that are sorted in the required order but to implement paging functionality using the TOP and SKIP keywords.

Limit result count

In most of the cases you will not need all of the content but only a few of them. Following example shows you how to get only the first 5 element in your queries result list:

Copy

GET https://example.com/OData.svc/Root?query=TypeIs:Car .TOP:5

🛈 Special characters should be URL encoded

Always use the TOP keyword whenever limiting result count is possible. TOP limits the size of temporary result arrays used in background query execution logic. Not providing .TOP keyword may result in unnecessary memory consumption and unreasonably high intensity GC usage!

Jump to page

In case you want to display a few content but not the first ones (for example in a pageable list of documents), use the keyword SKIP. The query below will skip the first 3 results and will return the second 3:

Copy

GET https://example.com/OData.svc/Root?query=TypeIs:Car .SKIP:3 .TOP:3

🛈 Special characters should be URL encoded

Ordering

Multiple predicates