Hello, I want to sort data based on the creation date, but nothing happens when I click on the header. I have enabled server-side pagination. And we have an ordering option available on the API. Just not sure how to trigger the API when header is clicked

Hey @Jack_T ! I couldn't understand why, but it didn't work when I used something like: ORDER BY {{table.sortArray[0].columnId}} {{table.sortArray[0].direction}} So in the end, I did the following solution. Not sure if there is a less verbose way, but it did work: ORDER BY CASE WHEN {{tab…

Sort columns when server side pagination is enabled

App Building

Justin_Greywolf November 14, 2023, 4:09pm 10

Unfortunately, most of the documentation on server-side pagination appears to be focused on the old table. So far I have been able to find that the property you are looking for is sortArray on the new table.

2 Likes