Open topic with navigation
When a query returns a large set of data, the results are returned in a series of pages. The client requests the next page after handling the data already received.
Pagination enables you to:
Retrieve a limited collection of results from the server.
Offset a collection of results from the server.
To paginate, use the keywords limit and offset.
On large collections, performance degrades when retrieving the later pages. Other ways to avoid stress on the database server, include restricting the size of data returned by the query by retrieving only the data you actually need:
Limit: Specifying the page size in the query
You can indicate the number of instances to return in each page using the query parameter.
limit has the following syntax: limit=<limit_value>
limit_value is an integer and must be greater than 0.
Caution: If the limit query parameter is less than 1 or greater than the maximum page size, an exception is thrown.
This limits the number of results in a resource collection returned from the server to a specific number of results.
The total_count property in the response states the actual number of entities that answer the filter (including the ones that are brought by the specific page).
If no limit parameter is provided, the default limit is used.
Offset: Specifying where to start a page
The query parameter offset sets the first position to return from the results of the query. The default is 0, which starts the page at the first result.
Offset has the following syntax:
offset_value is an integer and must be greater than or equal to 0.
This offsets the starting point of the collection returned from the server in the results.
If no offset parameter is provided, the number 0 is used.
Example: We have 100 defects in the system. To get 10 defects in places 40 – 49, send the following: