Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Plugins

Notices

Reply
 
Thread Tools Search this Thread
Old 02-04-2017, 04:48 PM   #181
KyBunnies
Book & Bunny Crazy
KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.KyBunnies ought to be getting tired of karma fortunes by now.
 
KyBunnies's Avatar
 
Posts: 1,019
Karma: 3416193
Join Date: Aug 2013
Location: USA
Device: K3 (x2), Fire HD 7-inch (x2), Fire HDX 8.9, Acer Android Tablet
Quote:
Originally Posted by DaltonST View Post
Just like Calibre itself, how MCS is used depends entirely on how and what you are trying to do. After you decide on a specific goal, read the Original Post, view its attached images, read the User Guide, then read the exhaustive ToolTips of the various Tabs within MCS itself. Then play with it, since you must teach yourself how to use it to do whatever it is you want to do. You cannot hurt anything by playing with it.

DaltonST
I am trying to find duplicate copies of books across all my libraries. It would be nice if SOMEONE could provide a little more info on how to actually use this plugin.
KyBunnies is offline   Reply With Quote
Advert
Old 02-04-2017, 05:40 PM   #182
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 883
Karma: 71334
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
Quote:
I am trying to find duplicate copies of books across all my libraries.
MCS is not the proper tool for doing that. CALM is exactly the right tool for that job.

https://www.mobileread.com/forums/sh...d.php?t=265947


DaltonST
DaltonST is offline   Reply With Quote
Old 04-13-2017, 05:15 AM   #183
Tanjamuse
Guru
Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!Tanjamuse , Klaatu Barada Niktu!
 
Posts: 842
Karma: 5258
Join Date: Jan 2014
Device: Samsung Galaxy Tab 3
Is there any way I can set this search criteria as standard instead of author and title?

Thanks
Attached Thumbnails
Click image for larger version

Name:	Skærmbillede 2017-04-13 11.14.35.png
Views:	65
Size:	53.7 KB
ID:	156156  
Tanjamuse is offline   Reply With Quote
Old 04-13-2017, 08:06 AM   #184
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 883
Karma: 71334
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
2 types of Cross-Library Queries

Quote:
Originally Posted by Tanjamuse View Post
Is there any way I can set this search criteria as standard instead of author and title?
There are 2 types of Cross-Library Queries: CL Intra-Book and CL Duplicates. See the attached image.

MCS will automatically validate your parameters and tell you of any parameter errors when you click the "Save Criteria" button.

DaltonST
Attached Thumbnails
Click image for larger version

Name:	cl_intrabook_query_versus_cl_duplicates_query.jpg
Views:	54
Size:	822.9 KB
ID:	156158  
DaltonST is offline   Reply With Quote
Old 04-25-2017, 11:55 AM   #185
taratears
Connoisseur
taratears began at the beginning.
 
Posts: 58
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?
taratears is offline   Reply With Quote
Old 04-25-2017, 12:39 PM   #186
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 883
Karma: 71334
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
The ToolTips are quite detailed and explain everything. I have attached them below.
Attached Thumbnails
Click image for larger version

Name:	mcs_fulltextsearch.jpg
Views:	44
Size:	371.4 KB
ID:	156368  
DaltonST is offline   Reply With Quote
Old 08-02-2017, 05:14 AM   #187
Katja_hbg
Enthusiast
Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.
 
Posts: 26
Karma: 118860
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
Katja_hbg is offline   Reply With Quote
Old 08-02-2017, 10:21 AM   #188
DaltonST
Deviser
DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.DaltonST knows who John Galt is.
 
DaltonST's Avatar
 
Posts: 883
Karma: 71334
Join Date: Aug 2013
Location: Texas
Device: 8" Win10 Tablet w/Calibre64
MCS and Ratings

Quote:
Originally Posted by Katja_hbg View Post
I try to see all books from an author when I mark at least one book of that author with 5 stars (my rating).
Katja:

See the attached image.


DaltonST
Attached Thumbnails
Click image for larger version

Name:	mcs_ratings.jpg
Views:	20
Size:	461.7 KB
ID:	158219  
DaltonST is offline   Reply With Quote
Old 08-02-2017, 01:17 PM   #189
Katja_hbg
Enthusiast
Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.Katja_hbg 's ceiling is 100% spider-free.
 
Posts: 26
Karma: 118860
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 )
Katja_hbg is offline   Reply With Quote
Reply

Tags
columns, search

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[GUI Plugin] Search the Internet kiwidude Plugins 283 06-28-2017 05:54 PM
[GUI Plugin] Walk Search History kiwidude Plugins 12 01-01-2017 10:31 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
[GUI Plugin] Clipboard Search kiwidude Plugins 9 08-12-2014 03:36 AM


All times are GMT -4. The time now is 12:13 AM.


MobileRead.com is a privately owned, operated and funded community.