Quote:
Originally Posted by Sidetrack
That does help, doesn't seem to handle the idenitfiers field that I can see.
|
@Sidetrack:
Both the 'Final Filters' Tab and 'SQL Queries' Tab handle identifiers. For your purposes, the 'SQL Queries' Tab should be used.
See the image below of an example using the 'SQL Queries' Tab.
Copy and paste this into that Tab:
Quote:
|
SELECT book FROM _mcs_tags_by_book WHERE tagname LIKE '%978%' OR tagname LIKE '%045%' OR tagname LIKE '%isbn%' OR tagname REGEXP '^[0-9][-]*[0-9][-]*[0-9][-]*[0-9][-]*[0-9][-]*[0-9][-]*[0-9][-]*[0-9][-]*[0-9][-]*[0-9]+$'
|
This will catch both 10-digit and 13-digit ISBNs with and without hyphens.
Table _mcs_tags_by_book is an MCS "Search Accelerator" table.
In lieu of using the latter table, you could JOIN standard Calibre tables tags and books_tags_link. However, if you have a lot of books with a lot of tags, that query will take
much longer to execute. Hence, the MCS "Search Accelerator" table.
By the way, the (industrial-strength) QuarantineAndScrub add-on automatically fixes the issues you described in your first post. The example in the image is from an actual Q&S test library with ISBN test cases.
DaltonST