Ignition v8.1.35
Perspective
I have a table bound to a named query that returns a list of orders. I have a Priority column which I would like to sort.
In the designer, I only have the Priority column selected as sortable and also have sort as ascending. Following the advice from other posts, I left the numberFormat to none.
In the designer, the table is sorted correctly. I can also change the sort property and the table will reflect the change in preview mode.
However, when I open the view in browser. I get this. Notice that the sort arrow is not selected.
No matter what I set the column's sort property to, the browser view does not change.
I have tried setting sortOrder, but that does not help.
The only way for the browser view to appear sorted is to add
ORDER BY [Priority] ASC
to the named query.
This works, but my expectation is that I should be able to configure the table columns to sort.