[Released] Pagination Bug?
Posted: Sun May 31, 2020 1:12 pm
Hello,
I am getting strange results using pagination. When the total number of records is less than the pageSize (which should only return 1 page of results), you get the same resultset by incrementing the page number. Take the following example:
/customers/companies/?page=1&pageSize=200&columns=ID,CompanyName&DateModified=gt(2020-01-01)
This returns 188 records (less than the pageSize of 200). Incrementing the page number to 2 (and 3,4...) returns the same 188 records (and the same header counts - resulttotal=188, resultpages=1, resultcount=188).
However, when the total number of records is MORE than the pageSize, the paging works as expected. In the above example, pageSize=100 will return 100 records on page 1, 88 records on page 2 and 0 records on page 3.
I am getting strange results using pagination. When the total number of records is less than the pageSize (which should only return 1 page of results), you get the same resultset by incrementing the page number. Take the following example:
/customers/companies/?page=1&pageSize=200&columns=ID,CompanyName&DateModified=gt(2020-01-01)
This returns 188 records (less than the pageSize of 200). Incrementing the page number to 2 (and 3,4...) returns the same 188 records (and the same header counts - resulttotal=188, resultpages=1, resultcount=188).
However, when the total number of records is MORE than the pageSize, the paging works as expected. In the above example, pageSize=100 will return 100 records on page 1, 88 records on page 2 and 0 records on page 3.