MobileRead Forums - View Single Post - Searching for custom column #rating with calibredb gives unkown sort field

chaley · Yesterday, 07:09 AM

You can display custom columns by replacing the '#' with a '*' as documented under --fields in the calibredb list documentation and help text. Example using #my_rating instead of #rating:

Code:

calibredb --with-library=. list --fields=*my_rating,title --sort-by=rating --ascending

However, you are currently not able to sort by a custom column. I've submitted changes to fix that. With my changes (assuming they are accepted by Kovid) you can use

Code:

calibredb --with-library=. list --fields=*my_rating,title --sort-by=*my_rating --ascending

Yesterday, 07:09 AM	#4
chaley Grand Sorcerer Posts: 12,509 Karma: 8065348 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	You can display custom columns by replacing the '#' with a '' as documented under --fields in the calibredb list documentation and help text. Example using #my_rating instead of #rating: Code: calibredb --with-library=. list --fields=my_rating,title --sort-by=rating --ascending However, you are currently not able to sort by a custom column. I've submitted changes to fix that. With my changes (assuming they are accepted by Kovid) you can use Code: calibredb --with-library=. list --fields=my_rating,title --sort-by=my_rating --ascending