View Single Post
Old 07-29-2016, 05:36 PM   #97
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
Protect/Unprotect Custom Columns

Quote:
In "Protect/Unprotect Custom Columns…" is would nice to have the ordering of the ID done correctly. At the moment it starts with 1 and continues with 11, 2-9 coming at the end of the list.
The "id" is the internal integer number assigned by Calibre for use in referring to its Custom Column tables. For example, a Custom Column with an id of 14 will have a table of custom_column_14, and depending on its datatype, it might also have a table called books_custom_column_14_link.

I included the "id" as pointer back to table custom_columns in metadata.db. That really means that JS+ converts that "id" from a string into an integer to use to update table custom_columns per the JS+ settings. It is also useful in comparing the JS+ window to that same table using a SQLite browser such as DB Browser for SQLite at http://sqlitebrowser.org/ .

The list is sorted alphabetically, which is much more user friendly.

See the attached.

If all of your Custom Columns begin with "#zotero_", it is less obvious, of course.



DaltonST
Attached Thumbnails
Click image for larger version

Name:	js_table_custom_column_sort_example.jpg
Views:	463
Size:	359.4 KB
ID:	150579  
DaltonST is offline   Reply With Quote