Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 04-26-2023, 04:16 AM   #1
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
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.

Click image for larger version

Name:	2023-04-26 05_10_17-Window.png
Views:	82
Size:	10.5 KB
ID:	201290

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?
Attached Files
File Type: zip metadata.zip (22.5 KB, 50 views)

Last edited by ownedbycats; 04-26-2023 at 04:40 AM.
ownedbycats is offline   Reply With Quote
Old 04-26-2023, 04:22 AM   #2
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
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.
ownedbycats is offline   Reply With Quote
Advert
Old 04-26-2023, 08:51 AM   #3
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
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.
chaley is offline   Reply With Quote
Old 04-26-2023, 09:47 AM   #4
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
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.
ownedbycats is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
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


All times are GMT -4. The time now is 06:12 AM.


MobileRead.com is a privately owned, operated and funded community.