View Single Post
Old 09-25-2022, 05:16 AM   #3
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,476
Karma: 8025702
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by Comfy.n View Post
Hi all,

I'm getting unexpected behaviour from this search using the Goodreads Plugin:

When using #r (my lookup name for the custom column containing the grrating identifier), #r:false returns 0 titles; when using identifiers:grrating:false the search returns the correct number of titles in the library that still don't have the grrating.

OTOH, both identifiers:grrating:true and #r:true queries return the titles that already have the grrating, as expected.

(i've tried renaming the custom column from #r to #gr, restarting Calibre, but that didn't help: searching for #gr:false returns a empty list)
What is the column type of #r? If it is a composite column (built from ...) then what is the template?

My guess is that the problem is related to confusion about what ':true' and ':false' mean in calibre searches. ':true' finds books with any value in the column and ':false' finds finds books with no value. For composites, empty is considered to be no value. For bool and bool-like columns, :false finds books with no value in the column, not columns containing 'No'.
chaley is offline   Reply With Quote