Enhance Full Text Search Results + Questions

mikhail_fil · 07-24-2023, 04:22 PM

It would be phenomenal if, when doing a Full Text Search, I could.

- Sort results by Number of Positive Hits per Book
- Increase number of words shown in the preview on the right, to be able to read more of "context" without opening the book.
- Export the search results together with the "context" paragraph.

I.E. Just did a search, got 198 books and papers.

DNSB · 07-24-2023, 04:55 PM

Personally, showing more context in the FTS box would be a bit useless since it only shows the first hit in a book and more than enough context for the hit in the right hand box.

My preference is to use FTS to locate books and then use the e-book viewer to open and search within the book.

Since FTS will take multiple search items with various options, perhaps a bit of work on creating searches would be a useful application of your time. See SQLite FTS5 Extension on the SQLite site for more information.

See attached images.

Comfy.n · 07-24-2023, 09:08 PM

Quote:

Originally Posted by mikhail_fil

- Export the search results together with the "context" paragraph.

Hi!

Kovid has added support for FTS to the calibredb command. Please check out this thread and see if this works for you:

https://www.mobileread.com/forums/sh....php?p=4342668

07-24-2023, 04:22 PM	#1
mikhail_fil Enthusiast Posts: 25 Karma: 10 Join Date: Jul 2016 Device: PC / ipad air	Enhance Full Text Search Results + Questions It would be phenomenal if, when doing a Full Text Search, I could. - Sort results by Number of Positive Hits per Book - Increase number of words shown in the preview on the right, to be able to read more of "context" without opening the book. - Export the search results together with the "context" paragraph. I.E. Just did a search, got 198 books and papers.

07-24-2023, 04:55 PM	#2
DNSB Bibliophagist Posts: 46,168 Karma: 168983734 Join Date: Jul 2010 Location: Vancouver Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos	Personally, showing more context in the FTS box would be a bit useless since it only shows the first hit in a book and more than enough context for the hit in the right hand box. My preference is to use FTS to locate books and then use the e-book viewer to open and search within the book. Since FTS will take multiple search items with various options, perhaps a bit of work on creating searches would be a useful application of your time. See SQLite FTS5 Extension on the SQLite site for more information. See attached images. Attached Thumbnails Last edited by DNSB; 07-24-2023 at 05:00 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Full-text search not really full-text	secasa	Library Management	5	10-01-2022 10:11 PM
Text Search results list not scrolling	BetterRed	Calibre	2	07-18-2022 07:17 PM
Amazon enhance search results	Little.Egret	General Discussions	10	10-27-2019 04:11 AM
Full text search?	excaliber	Library Management	3	08-07-2017 06:09 AM
Google Book Search to search full-text books online	Bob Russell	Deals and Resources (No Self-Promotion or Affiliate Links)	1	08-19-2006 12:13 PM

Advert