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
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: 355
Karma: 32554
Join Date: May 2014
Location: Canada
Device: Kobo Clara 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
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: 21,861
Karma: 22086630
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
Advert
Old 11-04-2014, 09: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,709
Karma: 2655880
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 10:01 AM.
chaley is offline   Reply With Quote
Old 11-04-2014, 12: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: 355
Karma: 32554
Join Date: May 2014
Location: Canada
Device: Kobo Clara 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 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 06:54 PM.


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