Provides properties and methods to work with paging.
Model-driven and canvas apps
First page number.
Whether the result set can be paged forwards.
Whether the result set can be paged backwards.
Last page number.
Page Number. Same as firstPageNumber. Used in exposed interfaces where firstPageNumber and lastPageNumber is not available.
The pageSize of the paging.
Total number of results on the server for the current query.
In case when value is not available
-1 is sent.
For Canvas Apps
totalResultCount will not always show the total number of records a table has. Because of delegation, it will return a value divisible by 500 until the last set of records is reached.
Let's say that a table has 1022 records in it. Your page size is 100. The following table shows the
totalResultCount value you can expect for each page:
|loadExactPage||Request the exact page of results to be loaded.|
|loadNextPage||Request the next page of results to be loaded.|
|loadPreviousPage||Request the previous page of results to be loaded.|
|reset||Reload the results from the server, and reset to page 1.|
|setPageSize||Sets the number of results to return per page on the next data refresh.|
loadPreviousPage do not support parallel execution.
Executing any of them will trigger
updateView on the control with newly fetched results.