Perspective table column sort property

Does anyone know how to get the sort property for column in perspective tables to work? I tried to find something in the user manual but was not successful. If I change the sort, ascending to none and use the sort icon at the top of the column it sorts just fine. Unfortunately saving the designer like this does not lock the sort in as default. I need the table to be rendered with this column sorted as default. I thought this setting on the column would do that. but it does not appear to do anything when I change it. Or I am missing something important to get it to work.

Sort the raw data in your binding.

1 Like

Good call, I used system.dataset.sort() to sort the dataset in code. that did the trick. Still wish I knew how that setting was supposed to work in the designer though.

You need to use the sortOrder property if you want the table to be sorted by default.
If the columns are specified with the sort property defined on them, the table will look at the sortOrder property to sort on load. There's examples in the manual:

1 Like