Sorting "Formats" colum

dancingbacon · 08-01-2011, 12:47 AM

Hey,

By default it seems that when sorting by the Formats column with multiple formats for each book, EPUB takes priority over MOBI and sorts by EPUB first. I want them all to sort with MOBI taking priority and being the first. Is there a way to do this?

Thanks.

PeterT · 08-01-2011, 12:57 AM

Looks like it does them in alphabetical order....

DoctorOhh · 08-01-2011, 01:17 AM

Quote:

Originally Posted by dancingbacon

By default it seems that when sorting by the Formats column with multiple formats for each book, EPUB takes priority over MOBI and sorts by EPUB first. I want them all to sort with MOBI taking priority and being the first. Is there a way to do this?

If you have more mobi than other formats then change the sort order (bottom of the tag browser) from Sort by Name to Sort by popularity.

chaley · 08-01-2011, 04:48 AM

The formats field is always sorted in alphabetical order.

If you want to distinguish MOBI from others, then in the current calibre you can create another custom column that has a value if there is a MOBI format, otherwise it doesn't. You could then sort on this column. The template would be something like

Code:

{formats:'in_list($, ',', 'MOBI', 'MOBI', '')'}

Another way is to search for format:=mobi and then sort however you wish.

In the next calibre release, you will be able to reorder the formats list to put MOBI in front. One template to do that is

Code:

{formats:'in_list($, ',', 'MOBI', merge_lists('MOBI', $, ','), $)'}

This doesn't work in the current release because the list is re-sorted after the merge.

08-01-2011, 12:47 AM	#1
dancingbacon Member Posts: 12 Karma: 10 Join Date: Jun 2011 Location: Canada Device: Kindle 3 Wi-Fi	Sorting "Formats" colum Hey, By default it seems that when sorting by the Formats column with multiple formats for each book, EPUB takes priority over MOBI and sorts by EPUB first. I want them all to sort with MOBI taking priority and being the first. Is there a way to do this? Thanks.

08-01-2011, 04:48 AM	#4
chaley Grand Sorcerer Posts: 12,443 Karma: 8012886 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	The formats field is always sorted in alphabetical order. If you want to distinguish MOBI from others, then in the current calibre you can create another custom column that has a value if there is a MOBI format, otherwise it doesn't. You could then sort on this column. The template would be something like Code: {formats:'in_list($, ',', 'MOBI', 'MOBI', '')'} Another way is to search for format:=mobi and then sort however you wish. In the next calibre release, you will be able to reorder the formats list to put MOBI in front. One template to do that is Code: {formats:'in_list($, ',', 'MOBI', merge_lists('MOBI', $, ','), $)'} This doesn't work in the current release because the list is re-sorted after the merge.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"Delver Magic" Trilogy - Jeff Inlo's series FREE in 8 different formats	Dr. Drib	Deals and Resources (No Self-Promotion or Affiliate Links)	99	06-25-2011 09:23 AM
Kindle "Sort by Author" is Sorting by First Name	SHydroxide	Calibre	2	01-13-2011 09:47 AM
The 2010 "Which formats are good to sell" poll	Steven Lyle Jordan	Lounge	24	03-21-2010 12:12 AM
"Sort By Author" not sorting correctly within author's collection	Sonist	Amazon Kindle	1	08-05-2009 07:52 PM

08-01-2011, 12:57 AM	#2
PeterT Grand Sorcerer Posts: 13,502 Karma: 78910112 Join Date: Nov 2007 Location: Toronto Device: Libra H2O, Libra Colour	Looks like it does them in alphabetical order....

Advert