I have implemented server side pagination with OFFSET in a SQL data query. I also have another SQL query returning a count for my data query and set this values as the “Total Record Count” field in my table settings.
It seems that the table settings totally ignore my “Total Record Count” value and allow the pagination to continue forever. Even if I put a fixed value as “Total Record Count” the pagination still continues without end.
I am using v1.6.10 of appsmith running in a docker container.