Custom Colunm Yes/No

onedot3 · 04-22-2011, 05:54 PM

I have a colunmn called To Read Lookup name toread Yes/No
when I do a search.
#toread:yes shows all books marked yes
#toread:checked shows all books marked yes
#toread:true shows all books marked yes

#toread:no shows all books marked no and undefined
#toread:unchecked shows all books marked no and undefined
#toread:false shows all books marked no and undefined

This happens with all my custom columns that are Yes/No

How do I get it to show me just the ones marked no

theducks · 04-22-2011, 08:01 PM

question for you: Do you have the tweak set for Yes/No to be Tri-state?

onedot3 · 04-23-2011, 06:07 AM

Do you mean the one in Teaks/Plugin tweaks

bool_custom_columns_are_tristate = 'yes'
The 'yes' is greyed

Have changed it to no
Still the same

chaley · 04-23-2011, 06:15 AM

You found a bug, introduced in 0.7.55. Searching incorrectly checks the new tristate preference, reversing its meaning. Thus, searching in tristate columns (ones with undefined values) incorrectly makes undefined and false into equivalent values.

A fix has been submitted, and should be in the next release.

Until the next release, the only workaround that I can think of is to create another custom column 'made from other columns'. Use {#boolcol} as the template, replacing #boolcol with the lookup name of your column. Set the search type to text. Search for 'Yes' to see true values, search for 'No' to see set-to-false values, and search for false to see undefined values.

onedot3 · 04-24-2011, 12:01 PM

Thanks for the replies
Will wait for the next release

04-22-2011, 05:54 PM	#1
onedot3 Nameless Being	Custom Colunm Yes/No I have a colunmn called To Read Lookup name toread Yes/No when I do a search. #toread:yes shows all books marked yes #toread:checked shows all books marked yes #toread:true shows all books marked yes #toread:no shows all books marked no and undefined #toread:unchecked shows all books marked no and undefined #toread:false shows all books marked no and undefined This happens with all my custom columns that are Yes/No How do I get it to show me just the ones marked no

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can custom book data be displayed in a custom column?	kiwidude	Development	9	03-02-2011 05:35 AM
0.7.46 and custom columns	meme	Library Management	4	02-21-2011 04:21 AM
Custom Recipe	CABITSS	Introduce Yourself	2	09-22-2009 10:30 AM
Custom Recipe	CABITSS	Calibre	3	09-22-2009 10:29 AM
Custom charge?	daoshi	iRex	3	10-06-2008 06:47 PM

04-22-2011, 08:01 PM	#2
theducks Well trained by Cats Posts: 30,897 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	question for you: Do you have the tweak set for Yes/No to be Tri-state?

04-23-2011, 06:07 AM	#3
onedot3 Nameless Being	Do you mean the one in Teaks/Plugin tweaks bool_custom_columns_are_tristate = 'yes' The 'yes' is greyed Have changed it to no Still the same

04-23-2011, 06:15 AM	#4
chaley Grand Sorcerer Posts: 12,336 Karma: 8012652 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	You found a bug, introduced in 0.7.55. Searching incorrectly checks the new tristate preference, reversing its meaning. Thus, searching in tristate columns (ones with undefined values) incorrectly makes undefined and false into equivalent values. A fix has been submitted, and should be in the next release. Until the next release, the only workaround that I can think of is to create another custom column 'made from other columns'. Use {#boolcol} as the template, replacing #boolcol with the lookup name of your column. Set the search type to text. Search for 'Yes' to see true values, search for 'No' to see set-to-false values, and search for false to see undefined values.

04-24-2011, 12:01 PM	#5
onedot3 Nameless Being	Thanks for the replies Will wait for the next release

Advert

Advert