Describe the bug

From my testing, the sorting priority is determined by the order of the columns, NOT by which column the user sorts first.

First test:

The numbers columns is in the left, so it takes priority even if it has the second sort

Second test

The letters columns is in the left, so it takes priority even if it has the second sort

steps to reproduce

1. enable DND in developer section
2. restart obsidian
3. drag the column to the desired order
4. restart obsidian
5. sort the two columns
6. repeat the last steps and swap the order of the column to confirm behavior

files to reproduce

test15.md
test14.md
test13.md
test12.md
test11.md
test10.md
test9.md
test8.md
testing database.md
test7.md
test6.md
test5.md
test4.md
test1.md
test3.md
test2.md

Expected behavior

The sorting priority should be determined by the order of the sorting, not by the order of the columns in the database.

Desktop and Obsidian

• macOS 12.3.1
• Obsidian 0.15.9