Add multi column sorting option to library

[jus]

It would be useful to be able to sort the library to more than one criterium. Just like in a spreadsheet application.

Example:
You sort by BPM , hold SHIFT and then sort by key.
You sort by artist , hold SHIFT and then sort by year.
....

[Daniel Schürmann (daschuer)]

This is an aspect related to bug #675057 "Filters for Library Columns"

I think we can do it without additional controls. Just keeping the last two sorts.

Example:
* First click header Bpm -> list is sorted by bpm
* secons click header year -> list is sorted by Year, if year is equal, it is still sorted by the last sort in this case BPM
* third click header genre -> list is sorted by Genre, if genre is equal it is still sorted by Year, if Genre and Year is equal it is sorted by BMP.

In addition to that we can define default secondary sorts, for example: when sorting by Album, secondary sort should always be track number.

An advanced version could be a grouped list view like many media player have.

[x (broma0-deactivatedaccount)]

I 100% agree with daschuer. Having the option to declare a secondary sort would make searching for songs in a large list much more efficient.

[Daniel Schürmann (daschuer)]

https://www.sqlite.org/lang_select.html
"ORDER BY artist, year"

[Owen Williams (ywwg)]

Does this work if I click twice on a column, reversing its sort?

[Daniel Schürmann (daschuer)]

Yes.
See: https://github.com/mixxxdj/mixxx/pull/465

[Daniel Schürmann (daschuer)]

This was just requested here:
http://www.mixxx.org/forums/posting.php?mode=reply&f=1&t=7095

[Swiftb0y (swiftb0y)]

Mixxx now uses GitHub for bug tracking. This bug has been migrated to:
https://github.com/mixxxdj/mixxx/issues/5851