Gerald Boutin <groupsio@...>
On Fri, Jun 21, 2019 at 05:50 AM, Andy W wrote:
Hi Shal,I agree with what Shal said about each column remembering its own direction. That resolves the issue of the "to start with" quandary. It will be whatever you left it at last. What it starts out at is immaterial.
To summarize further, one click to change to sort of a different column. Further clicks on the active column will toggle the sort direction for that column, and hence the table as well.
Life gets more complicated depending on how many sub-levels one wants to incorporate for breaking ties in the primary column. Ideally, it might be all columns with the last used column being the secondary key and next last used column, the next key and so on. In reality, probably one sub-column sub-level should be enough.