Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 11-04-2014, 08:14 AM   #1
MerlinMama
Evangelist
MerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beauty
 
MerlinMama's Avatar
 
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!
MerlinMama is offline   Reply With Quote
Old 11-04-2014, 09:26 AM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 29,790
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
theducks is offline   Reply With Quote
Advert
Old 11-04-2014, 09:58 AM   #3
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: 11,736
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.
chaley is offline   Reply With Quote
Old 11-04-2014, 12:09 PM   #4
MerlinMama
Evangelist
MerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beautyMerlinMama does all things with Zen-like beauty
 
MerlinMama's Avatar
 
Posts: 482
Karma: 32554
Join Date: May 2014
Location: Canada
Device: Kobo Sage
Quote:
Originally Posted by chaley View Post
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.
MerlinMama is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 08:27 AM.


MobileRead.com is a privately owned, operated and funded community.