Comment too large

[Doum]

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) ;

[georgemk]

This thread may help "Searching Library on Field Length" https://www.mobileread.com/forums/sh...d.php?t=349658

[chaley]

Use "Search using templates" (See the manual, scroll to find the "search using templates" documentation).

Example:


The template text is

program: if strlen($comments) ># 5000 then '1' else '' fi

[Doum]

Great thank both of you, exactly wth i want !!!! (and two solutions !!)