View Single Post
Old 07-24-2024, 08:34 PM   #1346
foosion
Evangelist
foosion is an enigma wrapped up in a mystery.foosion is an enigma wrapped up in a mystery.foosion is an enigma wrapped up in a mystery.foosion is an enigma wrapped up in a mystery.foosion is an enigma wrapped up in a mystery.foosion is an enigma wrapped up in a mystery.foosion is an enigma wrapped up in a mystery.foosion is an enigma wrapped up in a mystery.foosion is an enigma wrapped up in a mystery.foosion is an enigma wrapped up in a mystery.foosion is an enigma wrapped up in a mystery.
 
Posts: 479
Karma: 41524
Join Date: Sep 2011
Device: Kobo Libra 2 & Clara BW
Quote:
Originally Posted by chaley View Post
Actually, you should use #onkobo:yes. In calibre searches, the search term "true" tests whether a column as a value. For Yes/No columns, both Yes and No are values so "true" will find both of these. An empty cell has no value, so "true" won't find these.

#onkobo:no will find books with the value "no". It won't find "yes" or empty columns.

Of course, "true" will work if the column values are either "yes" or empty, and never "no".

The search documentation in the calibre manual goes into detail about the meaning of search terms.
Column values are either "yes" or empty, so both true and yes work. "Yes" seems the better course, just in case there's something else in the column, even if there shouldn't be.

Thank you for your patience answering my questions.
foosion is offline   Reply With Quote