02-04-2017, 04:48 PM | #181 | |
Book & Bunny Crazy
Posts: 1,291
Karma: 6468095
Join Date: Aug 2013
Location: USA
Device: K3 (x2), Fire HD 7-inch (x2), Fire HDX 8.9, Acer Android Tablet
|
Quote:
|
|
02-04-2017, 05:40 PM | #182 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Quote:
https://www.mobileread.com/forums/sh...d.php?t=265947 DaltonST |
|
Advert | |
|
04-13-2017, 05:15 AM | #183 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
Is there any way I can set this search criteria as standard instead of author and title?
Thanks |
04-13-2017, 08:06 AM | #184 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
2 types of Cross-Library Queries
Quote:
MCS will automatically validate your parameters and tell you of any parameter errors when you click the "Save Criteria" button. DaltonST |
|
04-25-2017, 11:55 AM | #185 |
Connoisseur
Posts: 77
Karma: 10
Join Date: Aug 2013
Device: Kindle Fire HD
|
I'm trying to figure out how to use this to do a full text search, and am apparently doing something incorrectly. Could I be walked thru the process of doing this, please?
|
Advert | |
|
04-25-2017, 12:39 PM | #186 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
The ToolTips are quite detailed and explain everything. I have attached them below.
|
08-02-2017, 05:14 AM | #187 |
Groupie
Posts: 167
Karma: 158116
Join Date: Oct 2015
Device: Kobo Glo HD (landscape), Kobo Aura One
|
I try to see all books from an author when I mark at least one book of that author with 5 stars (my rating).
- intra book search with "all author books" does not work as search seems to work with text only - intra book search (author left, my rating right with AND and =) does not show anything - SELECT id FROM books WHERE id IN (SELECT id FROM custom_column_18 WHERE value = 5) while _18 is my rating normalized column does not show anything So will this kind of search be possible and if so, please provide some guidance. Thanks |
08-02-2017, 10:21 AM | #188 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
MCS and Ratings
Quote:
See the attached image. DaltonST |
|
08-02-2017, 01:17 PM | #189 |
Groupie
Posts: 167
Karma: 158116
Join Date: Oct 2015
Device: Kobo Glo HD (landscape), Kobo Aura One
|
Thanks for your reply and help. It works now.
The tooltip did not help as I use rating with a custom column. Also that my column is offered in the drop down. Anyhow I got what I like with the SQL tab. For those who like to copy and paste please find here my sql. Replace "18" with the proper number of your customn column as shown in the tooltip on your screen. SELECT book FROM books_custom_column_18_link WHERE value IN (SELECT id FROM custom_column_18 WHERE value >=10 ) |
09-08-2017, 05:01 AM | #190 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
How do I use the search in this screenshot in a single library instead of searching for duplicates in 2 libraries?
|
09-08-2017, 10:32 AM | #191 | |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Quote:
[2] If you want to do an "Inter-Book Search", check the "Inter-Book Search" checkbox, and the screen will reconfigure itself for an "Inter-Book Search". [3] For example scenarios, see the many images attached to the Original Post of this thread. [4] Hover your mouse over each area and widget in the screen to read their respective ToolTips. [5] Remember to "Save Parameters", which will also validate your settings and issue any error messages. DaltonST |
|
09-08-2017, 04:43 PM | #192 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
I Think I've done as you suggested (see attached image) but I get an error when I select: Execute Search [all books].
The error is: Code:
calibre, version 3.6.0 ERROR: MCS: Cross-Library Duplicates Searches are never for 'All Books'. Use 'Another Library [All Books]' instead. Execution Canceled. |
09-08-2017, 05:10 PM | #193 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
You need to Save your criteria before clicking Execute. It thinks you still have "CL Duplicates" checked. As a last resort, Save, Exit, then rerun MCS. Your saved criteria will appear.
|
09-08-2017, 05:12 PM | #194 |
Wizard
Posts: 1,327
Karma: 5306
Join Date: Jan 2014
Device: none
|
Is it library specific settings or all-around?
|
09-08-2017, 05:13 PM | #195 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
What you see applies to MCS regardless of what the current library is.
|
Tags |
columns, search |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[GUI Plugin] Clipboard Search | kiwidude | Plugins | 29 | 04-02-2024 10:05 PM |
[GUI Plugin] Search the Internet | kiwidude | Plugins | 433 | 04-01-2024 05:48 PM |
[GUI Plugin] Walk Search History | kiwidude | Plugins | 38 | 03-17-2024 12:47 AM |
[GUI Plugin] Recoll Full Text Search | Satas | Plugins | 16 | 08-05-2016 03:54 AM |
[GUI Plugin] Full Text Search (SOLR) | peterpisljar | Plugins | 2 | 08-09-2015 08:16 AM |