View Single Post
Old 12-09-2023, 10:43 AM   #1
Doum
Connoisseur
Doum began at the beginning.
 
Posts: 60
Karma: 10
Join Date: Jun 2020
Device: Kobo Aura HD
Comment too large

Hi
I search a plugin or a simple command to search amidst my books all books with too large comment (exemple : > 5000 car )

Have you an idea ?

Thanks

PS: can you delete the same post in related tools please

PS : i use sql to do that , but i will prefere to do with calibre interface
SELECT books.id as booksid, title, author_sort as author, books.series_index as serie_index, series.name as serie_name , length(comments.text)
FROM books left outer join books_series_link on books.id = books_series_link.book left outer join comments on comments.book = books.id left outer join series on books_series_link.series = series.id
where length(comments.text) > 5000 order by length(comments.text) ;

Last edited by Doum; 12-09-2023 at 10:47 AM.
Doum is offline   Reply With Quote