07-21-2020, 05:23 PM | #1 |
Custom User Title
Posts: 8,644
Karma: 61234567
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Sorting and undefined values
When sorting a column A-Z, all the books with an undefined value in that column sort to the top. Aside from using columnname:true or using composite columns (still figuring out the template language), are there any workarounds to make them sort to the bottom while preserving the alphabetical order?
Last edited by ownedbycats; 07-21-2020 at 10:07 PM. |
07-22-2020, 11:59 AM | #2 |
Custom User Title
Posts: 8,644
Karma: 61234567
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
I was able to get the sort the way I wanted by using composite column.
Code:
program: test(field('#columnname'), 'Yes', '') |
07-22-2020, 01:03 PM | #3 | |
Grand Sorcerer
Posts: 11,742
Karma: 6997045
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
If you know a maximum value for a column, perhaps a composite field like this is better (assuming a text column): Code:
program: f = field('#columnname'); test(f, f, 'zzzzzzzzz') |
|
07-22-2020, 01:32 PM | #4 |
Custom User Title
Posts: 8,644
Karma: 61234567
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
It was mostly for View Manager sorting purposes. It does have the option to filter to a saved search but I also wanted to see the non-Yes books too. I might try that other column though.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Removal of undefined classes from text | mcdummy | Editor | 16 | 07-08-2020 07:45 AM |
Issues with decimal numbers sorting + sorting series but showing title first | TheRealAce | Devices | 3 | 12-23-2019 03:53 PM |
Is there way to list undefined classes? | phossler | Editor | 10 | 07-29-2018 09:33 PM |
Sorting tag values in tag browser | mcam | Library Management | 15 | 08-25-2013 05:50 AM |
PRS-600 Sony library - Error undefined | omk3 | Sony Reader | 13 | 01-22-2010 10:52 AM |