View Single Post
Old 03-06-2011, 02:23 PM   #11
CWatkinsNash
IOC Chief Archivist
CWatkinsNash ought to be getting tired of karma fortunes by now.CWatkinsNash ought to be getting tired of karma fortunes by now.CWatkinsNash ought to be getting tired of karma fortunes by now.CWatkinsNash ought to be getting tired of karma fortunes by now.CWatkinsNash ought to be getting tired of karma fortunes by now.CWatkinsNash ought to be getting tired of karma fortunes by now.CWatkinsNash ought to be getting tired of karma fortunes by now.CWatkinsNash ought to be getting tired of karma fortunes by now.CWatkinsNash ought to be getting tired of karma fortunes by now.CWatkinsNash ought to be getting tired of karma fortunes by now.CWatkinsNash ought to be getting tired of karma fortunes by now.
 
CWatkinsNash's Avatar
 
Posts: 3,932
Karma: 51698334
Join Date: Dec 2010
Location: Nashville, TN, USA
Device: Kindle Oasis, Fire HD 8+, Fire 10
Quote:
Originally Posted by chaley View Post
That search (not #read_status:"=Yes") won't work for a yes/no column. You must not use the equals sign. The quotes are unnecessary, but they don't hurt anything.

The search rules are:

1) booleans are tristate (the tweak is not changed)
a) You can look for empty values with any of:
#colname:empty
#colname:blank
#colname:false
b) You can look for 'false' values (red X) with any of:
#colname:no
#colname:unchecked
#colname:true
c) You can look for 'true' values (green check) with any of:
#colname:yes
#colname:checked
#colname:true

Note that #colname:true finds both red X and green check. That is because a search for true means search for 'set to something'.

2) booleans are NOT tristate (the tweak has been changed)
a) You can look for 'false' values (red X) or empty values with any of:
#colname:no
#colname:unchecked
#colname:false
b) You can look for 'true' values (green check) with any of:
#colname:yes
#colname:checked
#colname:true
Thanks for the info. I didn't notice that it wouldn't work that way because I modified the column type to text with fixed values (so I could include a "finish later" option). Because I was playing with it, I missed the fact that it started working only after I changed the column type. I'm not an effective troubleshooter on Sunday mornings.
CWatkinsNash is online now   Reply With Quote