budibase
budibase copied to clipboard
Enable On-Click sorting in tables with external data sources
Describe the feature request Feature Request from customer: Currently the old and new table components do no expose what column has been clicked on for sorting and do not allow us to disable user column sorting.
As we are using MSSQL queries we must rebuild the pagination ourselves which works but will provide in-correct sorting if the user clicks on a column header as its only sorting with the initial page of data the query returned. Ideally if we can capture either via a variable or via the table component outputs, the column name that has been sorted and its sort order we can pass these into our queries to perform the sort within the query itself.
Which boils down to
- Create settings toggle for the ability for the user to sort a table
- Surface the clicked-column to bindings for custom pagination sorted by column.