Sorting "Formats" column

dancingbacon · 11-23-2011, 02:33 PM

Hello,

I was using this custom template for my .mobi formats taking priority over all the other formats when sorting in a custom Formats column:

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

Recently, it stopped working.

Could someone explain why, and how to fix it? Or link me to somewhere where I could try rewriting it to get it to work again?

Thanks

chaley · 11-24-2011, 04:33 AM

That template will do what you want only if the composite column does not have the type "behaves like tags". If it has that type, the GUI always sorts the values.

As for why it stopped working, I have no idea. The code that sorts "behaves like tags" custom columns has been there for at least a year. Perhaps you changed the type of the column?

dancingbacon · 11-24-2011, 07:35 AM

It's put under "column built from other columns".

chaley · 11-24-2011, 07:46 AM

If you are saying that it is not "Column built from other columns, behaves like tags", then I can't tell you why it doesn't work.

For me, calibre behaves as you describe if the column type is "Column built from other columns, behaves like tags", but works works fine if the column type is "Column built from other columns".

This attachment shows the definition of the column that works (#composite).

Click image for larger version

Name: Clipboard01.jpg
Views: 221
Size: 38.9 KB
ID: 79312

This attachment shows the definition of the column that behaves as you describe (#comp2).

Click image for larger version

Name: Clipboard02.jpg
Views: 207
Size: 38.3 KB
ID: 79313

This attachment shows calibre's output for both columns.

Click image for larger version

Name: Clipboard03.jpg
Views: 174
Size: 22.3 KB
ID: 79314

dancingbacon · 11-24-2011, 03:00 PM

It's identical to the composite one. Mobi comes before everything except for Lit and Pdf.

theducks · 11-24-2011, 04:50 PM

Quote:

Originally Posted by dancingbacon

It's identical to the composite one. Mobi comes before everything except for Lit and Pdf.

Look for a Leading space on Mobi (" Mobi")
Then look for the cause

chaley · 11-25-2011, 03:34 AM

Quote:

Originally Posted by dancingbacon

It's identical to the composite one. Mobi comes before everything except for Lit and Pdf.

Thanks for providing some details on what didn't work so I could trace it. The fix is in today's release.

FYI: the fix for another bug (the same item could appear in the list more than once) caused this problem.

dancingbacon · 11-25-2011, 06:30 PM

Quote:

Originally Posted by chaley

Thanks for providing some details on what didn't work so I could trace it. The fix is in today's release.

Wonderful! Thank you so much!

11-23-2011, 02:33 PM	#1
dancingbacon Member Posts: 12 Karma: 10 Join Date: Jun 2011 Location: Canada Device: Kindle 3 Wi-Fi	Sorting "Formats" column Hello, I was using this custom template for my .mobi formats taking priority over all the other formats when sorting in a custom Formats column: {formats:'in_list($, ',', 'MOBI', merge_lists('MOBI', $, ','), $)'} Recently, it stopped working. Could someone explain why, and how to fix it? Or link me to somewhere where I could try rewriting it to get it to work again? Thanks

11-24-2011, 07:46 AM	#4
chaley Grand Sorcerer Posts: 11,733 Karma: 6690881 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	If you are saying that it is not "Column built from other columns, behaves like tags", then I can't tell you why it doesn't work. For me, calibre behaves as you describe if the column type is "Column built from other columns, behaves like tags", but works works fine if the column type is "Column built from other columns". This attachment shows the definition of the column that works (#composite). This attachment shows the definition of the column that behaves as you describe (#comp2). This attachment shows calibre's output for both columns.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom column: "Updated date", when adding new "versions" of the same file?	enriquep	Library Management	16	11-03-2011 10:46 AM
Sorting "Formats" colum	dancingbacon	Library Management	3	08-01-2011 04:48 AM
Kindle "Sort by Author" is Sorting by First Name	SHydroxide	Calibre	2	01-13-2011 09:47 AM
"Sort By Author" not sorting correctly within author's collection	Sonist	Amazon Kindle	1	08-05-2009 07:52 PM

11-24-2011, 04:33 AM	#2
chaley Grand Sorcerer Posts: 11,733 Karma: 6690881 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	That template will do what you want only if the composite column does not have the type "behaves like tags". If it has that type, the GUI always sorts the values. As for why it stopped working, I have no idea. The code that sorts "behaves like tags" custom columns has been there for at least a year. Perhaps you changed the type of the column?

11-24-2011, 07:35 AM	#3
dancingbacon Member Posts: 12 Karma: 10 Join Date: Jun 2011 Location: Canada Device: Kindle 3 Wi-Fi	It's put under "column built from other columns".

11-24-2011, 03:00 PM	#5
dancingbacon Member Posts: 12 Karma: 10 Join Date: Jun 2011 Location: Canada Device: Kindle 3 Wi-Fi	It's identical to the composite one. Mobi comes before everything except for Lit and Pdf.

Advert

Advert