Access to "title_sort" information from calibredb??

drawson1 · 11-24-2021, 05:26 PM

Is there any way to access the title sort information from calibredb using the existing data?

I was able to do it by creating a custom column based on the {title_sort} template, but it feels like duplicating information :-)

Thanks!

Dan

kovidgoyal · 11-24-2021, 10:27 PM

title_sort is not a normal field. Its mostly auto-generated though it can of course be edited. So its not accessible using calibredb. You can of course use a custom column to do it. And note that the column does not duplicate any data. A column with a template contains no data at all but is dynamically generated when used.

drawson1 · 11-26-2021, 06:32 AM

Very cool - thanks!

11-24-2021, 05:26 PM	#1
drawson1 Connoisseur Posts: 96 Karma: 10 Join Date: Mar 2014 Device: Libra H20, Clara 2E	Access to "title_sort" information from calibredb?? Is there any way to access the title sort information from calibredb using the existing data? I was able to do it by creating a custom column based on the {title_sort} template, but it feels like duplicating information :-) Thanks! Dan

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"calibredb catalog" and customized column with template	commandante	Library Management	2	07-19-2016 04:41 PM
command line "calibredb catalog" problems	Divingduck	Calibre	12	12-26-2014 06:01 PM
"Save to disc" using title instead of title_sort?	manawydan	Library Management	4	09-22-2013 02:52 AM
Defining Metadata with "calibredb add" command line function.	macr0t0r	Calibre	3	03-01-2012 08:36 PM
T1: plugboard "title_sort" doesn't work?	salines	Devices	0	11-05-2011 10:17 AM

11-24-2021, 10:27 PM	#2
kovidgoyal creator of calibre Posts: 45,609 Karma: 28549044 Join Date: Oct 2006 Location: Mumbai, India Device: Various	title_sort is not a normal field. Its mostly auto-generated though it can of course be edited. So its not accessible using calibredb. You can of course use a custom column to do it. And note that the column does not duplicate any data. A column with a template contains no data at all but is dynamically generated when used.

11-26-2021, 06:32 AM	#3
drawson1 Connoisseur Posts: 96 Karma: 10 Join Date: Mar 2014 Device: Libra H20, Clara 2E	Very cool - thanks!

Advert