[Bug]: Hidden columns don't influence sorting

[Lernos]

Contact Details

lernoskey@gmail.com

What happened?

I'm making a database for games of different genres, with different completion statuses and ratings. I need to be able to implement several sorting mechanisms, so that the games are sorted e.g. first by completion status, then by their rating and then by genre. To make updating the database and inserting new types of statuses and genres possible, I'm using two columns for each characteristic: one Tag-type column that contains the text (for example, "Completed" or "JRPG"), and one formula column that reads the text value and if it recognizes it, returns a number: 1, or 2, or 3 and so on. I'm then using the formula column to sort the database. By assigning ascending sorts to different columns in a different order, I can create the sorting I need, as explained above, first by status, then by rating, etc.

The problem is that I don't want to keep the formula columns with numbers in my database view because they're ugly and unnecessary for the UX viewing. Compare the following rows:

Final Fantasy 4 | JRPG | 4 | Excellent game | 1 | Completed | 3
Final Fantasy 4 | JRPG | Excellent game | Completed

The second one reads better, doesn't it? It doesn't clutter the screen with useless info telling the algorithm that when sorting, "JRPG" should be sorted after 3 other genres, "Excellent game" should be the first rating in its category, and "Completed" should be sorted after 2 other statuses.

When those formula columns containing numbers are in view, the sorting applies to the database immediately. But when I hide them, editing an existing row or adding a new one and filling the info in doesn't update its sorting. I know the database itself remembers those sorts exist, because if I sort a column by ascending order, then hide it and sort a different column without hiding it, the number "2" will appear next to its name, letting me know that it's the second sort that's applied to this database.

Besides, even the documentation says "You can hide the columns while keeping the underlying metadata". Then how come hiding some columns suddenly makes the database stop updating the sorting? I consider this to be a bug. But if it's working as intended somehow, I'd like this to be turned into a feature request instead.

Thank you :)

What platform were you using?

Desktop

Version of the plugin

3.5.1

Relevant log output

No response

Are you using the latest version of the plugin in your Obsidian vault?

• I have verified that I am on the latest version

Are you check if there is a similar issue?

• I have verified that there are not similar issues