[Bug]: The table displays incorrect data when server-side pagination is enabled, and the length of the last page is less than the pageSize value.

[phennapa-saeliw]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

The pageOffset value is working incorrectly if the last page of the table widget has a length less than the pageSize value.

Steps To Reproduce

1. Drag and drop a table widget
2. Using PostgreSQL as the datasource.
3. Click the 'Connect Data' button to select table, and Appsmith will automatically generate the query.
4. Appsmith use the pageOffset prop for query offset
5. Press the 'Next Page' button until reaching the last page, then press the 'Previous Page' button, the data displayed in the table will be incorrect, according to the example in the video.
6. The pageOffset value was 64 before changing to 80 on the pageNo = 9.

Public Sample App

https://app.appsmith.com/app/server-side-pagination/page1-66d1dde63ec3612915d62a75

Environment

Production

Severity

Medium (Frustrating UX)

Issue video log

https://www.loom.com/share/2036895ffb8941b1954183f982261f0e?sid=121fc0ef-e4f7-456c-9478-65173d7a534b

Version

Cloud - 1.38.0

[phennapa-saeliw]

I tried changing the query from using {{Table1.pageOffset}} to{{(Table1.pageNo - 1) * Table1.pageSize}} and found that when I clicked the next page until the last page (the last page must have fewer data items in the table than the pageSize value), and then clicked the prev page, the data displayed correctly.