07-14-2020, 02:57 PM | #286 |
Custom User Title
Posts: 8,629
Karma: 61234567
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Is it possible to compare two datetime columns from the same book? (My intended purpose is finding books where #fanficupdated is later than #lastread.) I checked the documentation and this thread and did not find anything about that.
What touch of SQL I know is only enough to compare to a fixed date. |
07-14-2020, 05:41 PM | #287 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Did you try using an Intrabook Query on the first Tab? That will answer your question.
SQL Queries are an entirely different Tab. DaltonST |
07-15-2020, 11:43 AM | #288 |
Custom User Title
Posts: 8,629
Karma: 61234567
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
I figured it out! I was a bit confused on what to put in the text boxes but after some trial-and-error it works now.
|
07-27-2020, 03:49 PM | #289 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.83 Inter/Intra Book Search Query: 'OPERATOR1' and 'OPERATOR2' defaulted
Version 1.0.83 - 27 July 2020 Inter/Intra Book Search Query: 'OPERATOR1' and 'OPERATOR2' defaulted to '='. Qt tweaks to accommodate small displays.
DaltonST |
08-08-2020, 09:47 AM | #290 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.84 "Post-Search" Tab: technical changes
Version 1.0.84 - 08 August 2020 "Post-Search" Tab: technical changes.
DaltonST |
10-21-2020, 07:34 PM | #291 |
Custom User Title
Posts: 8,629
Karma: 61234567
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Opening the User Guide from the menu failed with this error.
Code:
calibre 5.3 [64bit] embedded-python: True is64bit: True Windows-10-10.0.19041-SP0 Windows ('64bit', 'WindowsPE') ('Windows', '10', '10.0.19041') Python 3.8.5 Windows: ('10', '10.0.19041', 'SP0', 'Multiprocessor Free') Interface language: None Successfully initialized third party plugins: Barnes & Noble (1, 2, 16) && Calibre Power Search Plugin (1, 6, 0) && Clean Comments (0, 1, 0) && Comments Cleaner (1, 2, 1) && Count Pages (1, 10, 0) && Drop Search Results (1, 0, 10) && Embed Comic Metadata (1, 5, 0) && EpubCheck (0, 2, 3) && EpubMerge (2, 11, 0) && Extract ISBN (1, 5, 0) && FanFicFare (3, 24, 5) && Fantastic Fiction (1, 4, 0) && Favourites Menu (1, 0, 5) && Find Duplicates (1, 8, 3) && Generate Cover (1, 5, 25) && Goodreads (1, 5, 1) && Import List (1, 5, 1) && Job Spy (1, 0, 187) && Kindle hi-res covers (0, 5, 0) && Kobo Books (1, 8, 0) && Kobo Utilities (2, 11, 8) && KoboTouchExtended (3, 4, 1) && Library Codes (1, 0, 47) && Manage Series (1, 2, 11) && Modify ePub (1, 6, 1) && MultiColumnSearch (1, 0, 84) && Open With (1, 5, 12) && Quality Check (1, 10, 1) && Reading List (1, 6, 17) && Save To Format (0, 0, 6) && SmartEject (2, 3, 0) && View Manager (1, 5, 7) Traceback (most recent call last): File "calibre_plugins.multi_column_search.ui", line 3481, in view_user_instructions File "calibre_plugins.multi_column_search.ui", line 3516, in extract_documentation_from_zip TypeError: must be str, not bytes Last edited by ownedbycats; 10-21-2020 at 08:41 PM. |
10-22-2020, 10:32 AM | #292 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.85 - Zipfile strings for .pdf documentation
Version 1.0.85 - 22 October 2020 Zipfile strings for .pdf documentation.
DaltonST |
10-22-2020, 02:14 PM | #293 |
Custom User Title
Posts: 8,629
Karma: 61234567
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Thank you. It works now.
|
10-22-2020, 10:45 PM | #294 |
Custom User Title
Posts: 8,629
Karma: 61234567
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Question: For intrabook queries, is there a way to search for columns that are null or not null? Doing a text search using = or != on a wildcard works on text and number columns, but not dates.
I'm also unsure of how to search a bool column. I tried true/false and yes/no and they didn't work. For my current purposes I can just do marked:true #boolcolumn:yes/no after running the intrabook search but it'd be helpful to know in future. While I'm here: Is there any sort of "saved search" feature? Save Criteria only saves one at a time. Just making sure I didn't miss anything obvious. Thank you. Last edited by ownedbycats; 10-23-2020 at 02:33 AM. |
10-22-2020, 11:21 PM | #295 | |
Custom User Title
Posts: 8,629
Karma: 61234567
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
I figured out the first question. I saw this in the PDF manual, but misunderstood it as trying to match 0000-00-00 as a date:
Quote:
|
|
12-04-2020, 04:19 PM | #296 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Beta Version: Deleted due to New Release
Deleted due to New Release.
Last edited by DaltonST; 12-07-2020 at 05:43 PM. Reason: Deleted due to New Release. |
12-07-2020, 05:41 PM | #297 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.86 New: Saved (named) criteria for each Query Type/Tab Function
Version 1.0.86 - 07 December 2020 New: Saved (named) criteria for each Query Type/Tab Function.
DaltonST |
12-17-2020, 03:38 PM | #298 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Version 1.0.87 Miscellaneous technical changes to improve performance
Version 1.0.87 - 17 December 2020 Miscellaneous technical changes to improve performance.
DaltonST |
01-29-2022, 12:32 PM | #299 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
Qt6 Compatibility Testing for Calibre 5.99.4+
Qt6 Compatibility Testing for Calibre 5.99.4+
DaltonST. Last edited by DaltonST; 07-11-2022 at 12:39 PM. Reason: New test version attached. |
02-17-2022, 11:21 AM | #300 |
Deviser
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
|
New version using only Qt6 & Python 3
New version using only Qt6 & Python 3 has been attached here:
https://www.mobileread.com/forums/sh...8&postcount=25 DaltonST |
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 |