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.
[Released] Pagination Bug?
Forum rules
- Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
- No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
- Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
- Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
- Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
- Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
- Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
- Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
-
phil.jeffrey
- Posts: 2
- Joined: Sun May 31, 2020 1:02 pm
Re: Pagination Bug?
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).
Thanks for letting us know about this Phil, we will patch this issue in next simPRO release.
Muqeet
API Developer | simPRO Software Group
API Developer | simPRO Software Group
DEVELOPER CENTER