search on a yes/no column

richreads · 01-15-2012, 11:08 AM

Hi.
I created a new custom column called show - type Yes/No.
I set one book as yes in the show column and one book as no in the show column to test searching.

I tried a few searches show:true, show:=true, show:="true" and the equivalent for false and show:blank.
All my results came up with not results.

I seem to missing something basic with my search but I can't seem to see it.
can someone point out the correct syntax?

kiwidude · 01-15-2012, 11:18 AM

If it is a custom column, you need to put # in front of the name.
So use this:

#show:true

Synamon · 01-15-2012, 11:19 AM

Custom columns need a # before the lookup name. Search for #show:true or #show:yes.

alansplace · 01-15-2012, 11:20 AM

#show:yes or #show:no

richreads · 01-15-2012, 11:23 AM

Right -- as soon as I read the # I remembered reading that.
I know it was something simple.
Thank-you for all the replies

01-15-2012, 11:08 AM	#1
richreads Connoisseur Posts: 53 Karma: 10 Join Date: Mar 2009 Location: Hamilton, ON Device: Kobo Touch and Glo,	search on a yes/no column Hi. I created a new custom column called show - type Yes/No. I set one book as yes in the show column and one book as no in the show column to test searching. I tried a few searches show:true, show:=true, show:="true" and the equivalent for false and show:blank. All my results came up with not results. I seem to missing something basic with my search but I can't seem to see it. can someone point out the correct syntax?

01-15-2012, 11:19 AM	#3
Synamon Lunatic Posts: 1,691 Karma: 4386372 Join Date: Dec 2011 Location: Land of the Loonie Device: Kindle Paperwhite and Keyboard, Kobo Aura, iPad mini, iPod Touch	Custom columns need a # before the lookup name. Search for #show:true or #show:yes. Last edited by Synamon; 01-15-2012 at 11:20 AM. Reason: too slow

01-15-2012, 11:20 AM	#4
alansplace Grand Sorcerer Posts: 5,886 Karma: 464403178 Join Date: Feb 2010 Location: 33.9388° N, 117.2716° W Device: Kindles K-2, K-KB, PW 1 & 2, Voyage, Fire 2, 5 & HD 8, Surface 3, iPad	search on a yes/no column #show:yes or #show:no

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Q: multi-column PDF to single column mobi format converstion	auburn1975	Calibre	7	01-28-2012 06:11 PM
custom date column from two state column	Dopedangel	Library Management	7	01-03-2012 08:20 AM
No search/replace on custom long text column?	CWatkinsNash	Library Management	2	06-20-2011 05:57 PM
User Column Search	spruce	Calibre	9	01-15-2011 04:01 PM
pdf to lrf with 2 column and 1 column pages in same file	danielwille	Sony Reader	3	11-12-2008 10:57 AM

01-15-2012, 11:18 AM	#2
kiwidude Calibre Plugins Developer Posts: 4,637 Karma: 2162064 Join Date: Oct 2010 Location: Australia Device: Kindle Oasis	If it is a custom column, you need to put # in front of the name. So use this: #show:true

01-15-2012, 11:23 AM	#5
richreads Connoisseur Posts: 53 Karma: 10 Join Date: Mar 2009 Location: Hamilton, ON Device: Kobo Touch and Glo,	Right -- as soon as I read the # I remembered reading that. I know it was something simple. Thank-you for all the replies

Advert

Advert