Series Sorting with hierarchy

[Dopedangel]

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

[chaley]

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:

{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

program: strcat(subitems(field('series'), 0,1), ':', format_number(field('series_index'), '{0:06.2f}'))

[Lynx-lynx]

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.