![]() |
#1 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 10,969
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Unexpected sorting behaviour
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? ![]() Last edited by ownedbycats; 04-26-2023 at 04:40 AM. |
![]() |
![]() |
![]() |
#2 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 10,969
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
I meant to put this in Library Management. Oops...
EDIT: Thank you moderator! Last edited by ownedbycats; 04-26-2023 at 04:28 AM. |
![]() |
![]() |
Advert | |
|
![]() |
#3 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 12,443
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
This is sorting as intended. If doing a multisort, higher-level columns with the same value (in this case empty) are sorted by the next level. In this case the next level (readinglist) is sorted ascending, where empty values are less than non-empty values, so they appear above. The equal (empty) readinglist values are sorted by lastread. This gives what you see.
If you want something different then you need to make a composite (probably not displayed) that generates values that sort how you want. For example using ZZZZZ for empty values, as we talked about before. |
![]() |
![]() |
![]() |
#4 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 10,969
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
In this specific case I just modified #currentlyreading to account for books still on the reading-list after completion.
|
![]() |
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom Column Filter - Unexpected behaviour | Comfy.n | Library Management | 21 | 09-25-2022 06:03 PM |
Unexpected behaviour of the Calibre "e-book editor" | WalterWalter | Editor | 2 | 02-18-2022 05:24 AM |
Test behaviour different to Calibre behaviour | louwin | Library Management | 2 | 04-12-2012 07:34 PM |
Unexpected filtering behaviour with the device | ryderark | Calibre | 8 | 10-22-2011 06:00 AM |
First time user unexpected behaviour | dasmotiu | Calibre | 2 | 12-14-2010 07:33 AM |