What went wrong?

If I sort my library by read status, it sorts each book alphabetically by the status set; "abandoned" -> "on hold" -> "read" -> "reading" -> "re-reading" -> "skimmed" -> "unread" -> "want to read". However, despite showing an "unread" status, newly-imported books sort at the end.

Steps to reproduce

1. Import several books into the library (I used Calibre).
2. Set the top sorting field to "Read Status", and add a second sort level for "Author".
3. Set the status of a book to "Unread".

The book will be placed in front of the other "unread" books, regardless of the author.

Expected vs actual behavior

It seems that, despite showing "unread" status, newly-imported books actually have a "null" status, so they will always be sorted last.

To fix this, I suggest sorting all "unread" books at the end of the library. If the user selects "unread" status for a book, it will be set to the same internal "null" status as newly-imported books. (Alternatively, set books' status to "unread" when importing.)

Your setup

• BookOrbit version: v1.10.0
• Deployment: Docker (ghcr.io/bookorbit/bookorbit:latest)
• OS: Debian 13
• Browser: Firefox 151.0.3 (64-bit)

Relevant logs (optional)

Screenshots (optional)

No response

Before submitting

• I've searched existing issues and this hasn't been reported yet.