Searching for empty

tadas · 04-19-2015, 08:41 PM

I have a user-defined field, #kindlecollections, that I use to maintain categories in conjunction with the Kindle Collections plugin. It's defined as comma-separated text. I want to search and create a virtual library with all books in the library where this field is not defined. The following are among the things I've tried that don't work:

#kindlecollections:" "
#kindlecollections:""
#kindlecollections = " "
#kindlecollections EQ " "

Reading http://manual.calibre-ebook.com/regexp.html was not helpful.

I've used grep and cousins and various kinds of SQL for a third of a century, and I'm frustrated. I don't need the concepts explained; I need a pointer to the *exact* syntax.

theducks · 04-19-2015, 08:43 PM

false is what you want

eschwartz · 04-20-2015, 12:14 AM

You're overthinking it

http://manual.calibre-ebook.com/gui.html#search-sort

tl;dr

Code:

columnname:search

"search" can be a true/false selector, or a string or regex match. You want:

Code:

#kindlecollections:false

04-19-2015, 08:41 PM	#1
tadas Member Posts: 15 Karma: 10 Join Date: Dec 2009 Device: Kindle	Searching for empty I have a user-defined field, #kindlecollections, that I use to maintain categories in conjunction with the Kindle Collections plugin. It's defined as comma-separated text. I want to search and create a virtual library with all books in the library where this field is not defined. The following are among the things I've tried that don't work: #kindlecollections:" " #kindlecollections:"" #kindlecollections = " " #kindlecollections EQ " " Reading http://manual.calibre-ebook.com/regexp.html was not helpful. I've used grep and cousins and various kinds of SQL for a third of a century, and I'm frustrated. I don't need the concepts explained; I need a pointer to the exact syntax.

04-20-2015, 12:14 AM	#3
eschwartz Ex-Helpdesk Junkie Posts: 19,422 Karma: 85397180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	You're overthinking it http://manual.calibre-ebook.com/gui.html#search-sort tl;dr Code: columnname:search "search" can be a true/false selector, or a string or regex match. You want: Code: #kindlecollections:false

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Glo Your library is empty	veloopity	Kobo Reader	7	05-12-2013 06:18 AM
Spine is empty?	artbatista	Conversion	44	07-01-2012 02:37 PM
Empty Books	philandjan	Library Management	8	03-11-2011 06:03 PM
Bebook is empty	Lake person	BeBook	15	08-30-2009 02:09 PM
Searching for empty tags	iain_benson	Calibre	2	01-27-2009 05:04 PM

04-19-2015, 08:43 PM	#2
theducks Well trained by Cats Posts: 29,812 Karma: 54830978 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	false is what you want

Advert