Custom column virtual library

MerlinMama · 11-04-2014, 08:14 AM

I was trying to create a virtual library based on my "Read" custom column. This column has a date, so I can't simply put 'true' or 'false'.

I tried {#read=" "}(without the brackets, don't worry), which gave me WITH a date in the column, so then I tried {not #read=" "}, which seemed to work fine, except I get 4 with a read date, and one without a read date which doesn't show up.

Any ideas, or should I abandon this?

Thanks!

theducks · 11-04-2014, 09:26 AM

You need a date value (range)
I use:

Code:

>=01-01-2000

chaley · 11-04-2014, 09:58 AM

You can use true or false. Assuming your column's lookup name is #read (seems to be from your examples), then #read:true will find all books that have something in the column, and #read:false will find all books that have nothing in the column.

The { and } characters are used in templates, not in searches. EDIT: But perhaps you know this, given the "don't worry" comment.

MerlinMama · 11-04-2014, 12:09 PM

Quote:

Originally Posted by chaley

You can use true or false. Assuming your column's lookup name is #read (seems to be from your examples), then #read:true will find all books that have something in the column, and #read:false will find all books that have nothing in the column.

The { and } characters are used in templates, not in searches. EDIT: But perhaps you know this, given the "don't worry" comment.

I had tried the 'false', but put in the ' =" ' as well, because I thought it had to be in there. At least now I know I was on the right track, just putting too much in there.

Thanks so much, it's worked like a charm!

And yes, I did know about the { }, still good to point out just in case.

11-04-2014, 08:14 AM	#1
MerlinMama Evangelist Posts: 482 Karma: 32554 Join Date: May 2014 Location: Canada Device: Kobo Sage	Custom column virtual library I was trying to create a virtual library based on my "Read" custom column. This column has a date, so I can't simply put 'true' or 'false'. I tried {#read=" "}(without the brackets, don't worry), which gave me WITH a date in the column, so then I tried {not #read=" "}, which seemed to work fine, except I get 4 with a read date, and one without a read date which doesn't show up. Any ideas, or should I abandon this? Thanks!

11-04-2014, 09:26 AM	#2
theducks Well trained by Cats Posts: 29,801 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	You need a date value (range) I use: Code: >=01-01-2000

11-04-2014, 09:58 AM	#3
chaley Grand Sorcerer Posts: 11,741 Karma: 6997045 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	You can use true or false. Assuming your column's lookup name is #read (seems to be from your examples), then #read:true will find all books that have something in the column, and #read:false will find all books that have nothing in the column. The { and } characters are used in templates, not in searches. EDIT: But perhaps you know this, given the "don't worry" comment. Last edited by chaley; 11-04-2014 at 10:01 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create virtual library based on custom metadata	maxwelledison	Library Management	2	03-12-2014 12:02 PM
Copy Custom Column to another library	gabby98	Calibre	10	01-26-2014 10:59 PM
Help with custom search to create virtual library	BunnyGal	Library Management	10	01-09-2014 07:56 PM
Custom column returns value based on value of another custom column?	calvin-c	Calibre	3	09-14-2013 02:24 PM
Library - Custom Column with File Name	AmerInstOfBi	Library Management	3	04-26-2013 11:29 AM