[Feature]: Enable directly setting the page number in Table Widget

[narhzih]

Is there an existing issue for this?

• [X] I have searched the existing issues

Summary

For a table widget, when using server-side pagination, I'm not allowed to specify a page number my user can jump to (the way it works with client-side pagination).

Why should this be worked on?

If we have a lot of data, it can be very hard to go from page 1 - page 100. Users will have to click a lot of times before eventually reaching their default page. If there's a way to specify a page number, then users will be able to navigate easily between pages of the table.

[ame-appsmith]

Another user requested this feature.

[Mace111]

+1 Same use case as narhzih described in "Why should this be worked on?"

[Nikhil-Nandagopal]

The challenge with storing the value in the query is that the table still shows the wrong number on page load