Register Guidelines E-Books Search Today's Posts Mark Forums Read

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

Notices

Reply
 
Thread Tools Search this Thread
Old 11-23-2012, 09:47 PM   #1
Dopedangel
Wizard
Dopedangel ought to be getting tired of karma fortunes by now.Dopedangel ought to be getting tired of karma fortunes by now.Dopedangel ought to be getting tired of karma fortunes by now.Dopedangel ought to be getting tired of karma fortunes by now.Dopedangel ought to be getting tired of karma fortunes by now.Dopedangel ought to be getting tired of karma fortunes by now.Dopedangel ought to be getting tired of karma fortunes by now.Dopedangel ought to be getting tired of karma fortunes by now.Dopedangel ought to be getting tired of karma fortunes by now.Dopedangel ought to be getting tired of karma fortunes by now.Dopedangel ought to be getting tired of karma fortunes by now.
 
Dopedangel's Avatar
 
Posts: 1,063
Karma: 8498867
Join Date: Dec 2006
Location: Singapore
Device: Coolreader(Nexus 5)\Coolreader(Nook Touch)
Series Sorting with hierarchy

Is it possible for the series with hierarchy to be sorted by the main series numbers I can achieve that in my device using send to but inside calibre the columns sort by series name instead of number first

At the moment in calibre columns it is sorting as

Orb 11
Orb 12
Orb.Malloreon 6
Orb.Malloreon 7
Orb.Malloreon 8
Orb.Malloreon 9
Orb.Malloreon 10
Orb.The Belgariad 1
Orb.The Belgariad 2
Orb.The Belgariad 3
Orb.The Belgariad 4
Orb.The Belgariad 5

I would prefer it to sort as

Orb.The Belgariad 1
Orb.The Belgariad 2
Orb.The Belgariad 3
Orb.The Belgariad 4
Orb.The Belgariad 5
Orb.Malloreon 6
Orb.Malloreon 7
Orb.Malloreon 8
Orb.Malloreon 9
Orb.Malloreon 10
Orb 11
Orb 12
Dopedangel is offline   Reply With Quote
Old 11-24-2012, 04:26 AM   #2
chaley
"chaley", not "charley"
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: 4,702
Karma: 800144
Join Date: Jan 2010
Location: France
Device: Many android devices
The only way to do this is to create a composite custom column (col built from other cols) and populate it with the first item in the series hierarchy. Something like the following template:
Code:
{series:subitems(0,1)||:}{series_index:>06.2f}
The template adds the series number with leading zeros so that it is sorted by series name then series number.

If you have a large library then the following template general program mode template will be faster because calibre will compile it into python
Code:
program: strcat(subitems(field('series'), 0,1), ':', format_number(field('series_index'), '{0:06.2f}'))
chaley is offline   Reply With Quote
Old 11-24-2012, 04:30 AM   #3
Lynx-lynx
The look ....
Lynx-lynx ought to be getting tired of karma fortunes by now.Lynx-lynx ought to be getting tired of karma fortunes by now.Lynx-lynx ought to be getting tired of karma fortunes by now.Lynx-lynx ought to be getting tired of karma fortunes by now.Lynx-lynx ought to be getting tired of karma fortunes by now.Lynx-lynx ought to be getting tired of karma fortunes by now.Lynx-lynx ought to be getting tired of karma fortunes by now.Lynx-lynx ought to be getting tired of karma fortunes by now.Lynx-lynx ought to be getting tired of karma fortunes by now.Lynx-lynx ought to be getting tired of karma fortunes by now.Lynx-lynx ought to be getting tired of karma fortunes by now.
 
Lynx-lynx's Avatar
 
Posts: 1,745
Karma: 17231384
Join Date: May 2012
Location: Australia
Device: Blackberry Playbook, Sony 650, Kobo Glo
Dopedangel it seems that the sort order is:

first alpha Orb

then number 11

Then alpha Malloreon

then alpha The

So change your words around to reflect the order you want it to sort.

I'd be interested to hear how it works.

Last edited by Lynx-lynx; 11-24-2012 at 07:25 AM.
Lynx-lynx is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Series Sorting the2ems Library Management 5 09-10-2012 07:31 AM
Tag browser Series hierarchy Dopedangel Library Management 4 06-15-2012 06:20 AM
Series sorting in plugboard ac4lt Devices 6 01-13-2012 12:53 PM
Touch Series/Collections sorting Nakaleen Kobo Reader 9 11-04-2011 09:01 PM
Sorting When Viewing Series Lady Fitzgerald Calibre 3 04-23-2010 10:34 AM


All times are GMT -4. The time now is 10:58 AM.


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