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