Create a function for Server Pagination Sort By feature to be applied to the whole table

What is the problem or goal the end user is trying to solve or accomplish?

Server Pagination is intended to help with charts and dashboard performance, especially if the table has a lot of data. That is why the current Sort By function is only applied to the current page, instead of the whole table. This is so that Preset will not need to send another query to the database to perform this sorting.

However, in some use cases, the user would like the Sort By to be applied to the whole table, even though the Server Pagination is enabled.

How are they solving it currently?

Access the Chart directly and change the Sort By of the whole table.

What is the recommended solution by the Customer?

Without having to change the sorting of the whole table from the Chart Builder page, create an option to be able to apply the sorting of the whole table on the fly, even with the Server Pagination enabled.