Status: To Do
Fix Version/s: None
Firefly does not currently support multiple-column sorting of tables.
A workaround for this, in general, can be to first sort on one column, and then change to sorting on another. This works if the sort is "stable", i.e., if, when sorting on column A, all rows with the same value for A stay in the same order they were in before the sort.
Some sort algorithms are "stable" and some are not. Stable algorithms in general have a performance penalty compared to the very most efficient sort algorithms.
I'm reporting this as an "improvement" ticket (i.e., not as an actual work assignment) because superficially this would be helpful to users, but I don't understand what the performance penalty might be, or if the HSQLDB back end even has support for this. This can become part of a Design ticket in the FIREFLY system.