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, 09:14 AM   #1
MerlinMama
Addict
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: 352
Karma: 32554
Join Date: May 2014
Location: Canada
Device: Kobo Aura Edition 2; Kobo Glo HD
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
Advert
Old 11-04-2014, 10: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: 21,351
Karma: 20890066
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: K4NT, Galaxy Tab 2(RIP)
You need a date value (range)
I use:
Code:
>=01-01-2000
theducks is offline   Reply With Quote
Old 11-04-2014, 10:58 AM   #3
chaley
CC Android & calibre dev
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: 8,575
Karma: 2644284
Join Date: Jan 2010
Location: France
Device: Many android devices
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 11:01 AM.
chaley is offline   Reply With Quote
Old 11-04-2014, 01:09 PM   #4
MerlinMama
Addict
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: 352
Karma: 32554
Join Date: May 2014
Location: Canada
Device: Kobo Aura Edition 2; Kobo Glo HD
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 01:02 PM
Copy Custom Column to another library gabby98 Calibre 10 01-26-2014 11:59 PM
Help with custom search to create virtual library BunnyGal Library Management 10 01-09-2014 08:56 PM
Custom column returns value based on value of another custom column? calvin-c Calibre 3 09-14-2013 03:24 PM
Library - Custom Column with File Name AmerInstOfBi Library Management 3 04-26-2013 12:29 PM


All times are GMT -4. The time now is 11:40 PM.


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