In one VL, I have this sorting order:
1. A composite column (#currentlyreading) that returns yes/undefined, sorted ascending
2. A series-like column (#readinglist), sorted ascending
3. A datetime column (#lastread), sorted descending.
I recently finished a book. This means that:
1. #currentlyreading was undefined
2. #readinglist was set to about halfway through the 'to be read' series
3. The date was was the most recent one in the VL.
Judging from this, I would've expected to find the book just
after everything in #currentlyreading. Instead, I found it at the bottom of the list.
This doesn't happen if the composite is set or the series-like is not set.
I was able to replicate this with a test library with stripped-down data.
I've also attached the test library db for inspection - if the View Manager plugin is installed it can be used to apply the sorts.
What exactly is going on here? Is it expected, or did I come across another glitch?
