Quote:
Originally Posted by laji
Have you got a more explained help, my be, with examples? To say the truth, I can not understand anything, how it works. All the help, when anything fails, is a word "ERROR"...
For example, how must I fill the fields and choose the relations, if I want to find books, where title<>title_sort? Thank you in advance.
Edit: or, maybe, is there a way to do this in standard Calibre? This like searches were the case to install your plugin, but I can not use it.
|
@laji:
It would seem that you are not choosing from the "
Calibre Columns Available for Searching using MCS", each of which is explained in detail on Page 2 of the User Guide. To summarize, they are:
- custom columns (Any) (#........)
- authors (but 'author' will work too)
- title
- series
- tags
- publishers
- comments
- pubdate (but 'published' will work too)
- path
For example, you are asking why you get an error when you search using "title<>
title_sort". Nowhere above, nor on Page 2 of the User Guide, exists "
title_sort" as a "
Calibre Column Available for Searching using MCS".
If you wish to learn more about the definition and use of "
Lookup/Search Name(s)" in the Calibre GUI, which is key to using MCS, I highly recommend this link:
http://manual.calibre-ebook.com/gui.html#the-search-interface .
Hovering your mouse over a "Column" in the GUI will expose its "
Lookup/Search Name". That is the name to use in MCS if you wish to use that particular "Column".
Since
"title_sort" is not a "Standard Column", the only way to use it is to make it visible in the Calibre GUI as a "Custom Column" called, for example, "#titlesort". You could then use it in MCS. Of course, you will have to populate it first from "books.sort".
To populate a "Custom Column" from an arbitrary SQLite table column in metadata.db, I refer you to useful documentation: embedded within the Calibre GUI;
http://manual.calibre-ebook.com;
http://manual.calibre-ebook.com/db_api.html; and others.
I would recommend to you a much faster and easier way to answer transient questions about the data. Simply create a list using 'calibredb --list' as outlined in
http://manual.calibre-ebook.com/cli/calibredb.html.
Import the list created above into a spreadsheet application, and use the standard spreadsheet text functions to manipulate the data in order to answer your questions.
Personally, I would use an even faster and easier way than the prior method. Connect to metadata.db using a SQLite browser, and then execute this native SQL: SELECT id,title,sort FROM books WHERE title <> sort . Then, export the results.
Example output: "2631" "The 9th Judgment" "9th Judgment, The"
Best of luck.
DaltonST