View Single Post
Old 03-27-2011, 01:30 PM   #8
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,471
Karma: 8025600
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by theducks View Post
BTW what is the search syntax for a tri-state T-F field to return blank or No (#ok_fc:false only returns blanks)
From the manual:
Quote:
Yes/no custom columns are searchable. Searching for false, empty, or blank will find all books with undefined values in the column. Searching for true will find all books that do not have undefined values in the column. Searching for yes or checked will find all books with Yes in the column. Searching for no or unchecked will find all books with No in the column.
Yes, it is strange that searching for 'true' will find 'false'. However, 'true' searches mean find *any* value, and 'false' is a value...

EDIT: A direct answer to the question: not #ok_fc:yes

Last edited by chaley; 03-27-2011 at 01:39 PM.
chaley is offline   Reply With Quote