Grouping / subqueries in library search

punkadiddle · 04-14-2013, 03:55 AM

Looking at the search manual, I don't suppose there's anything like subqueries to express things like

all books authors by authors of whom i've read at least three books and rated > 3 stars (I have a column to mark books as read) or
all books that are part of a series of which I have read at least one book

or is there? Does the manual cover the potential of the search language or are there a lot of exciting "extras" to be found in the underlying manual of the programming language?

I would find the kind of queries quite helpful to get back to an author or series after a while.

chaley · 04-14-2013, 04:15 AM

Calibre's search cannot do queries that require information from more than one book. The search expression can "see" only the information for the current book. This is also true of the template language.

Arbitrary queries can be done in a plugin, but of course plugins requires programming.

Some people have done similar things using SQL against the raw database to generate reports.

04-14-2013, 03:55 AM	#1
punkadiddle Junior Member Posts: 9 Karma: 10 Join Date: Apr 2013 Device: Kobo	Grouping / subqueries in library search Looking at the search manual, I don't suppose there's anything like subqueries to express things like all books authors by authors of whom i've read at least three books and rated > 3 stars (I have a column to mark books as read) or all books that are part of a series of which I have read at least one book or is there? Does the manual cover the potential of the search language or are there a lot of exciting "extras" to be found in the underlying manual of the programming language? I would find the kind of queries quite helpful to get back to an author or series after a while.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to search the contents of my library	mfaine	General Discussions	1	02-16-2013 12:51 PM
search within all books in library	occum	Calibre	2	12-05-2012 02:00 PM
Author Grouping - Just numbers	wetrix	Calibre	2	08-14-2011 05:57 AM
Classic Search the Library?	drzenitram	Barnes & Noble NOOK	8	08-04-2010 02:02 PM
Grouping identical books inside calibre	joselitux	Calibre	4	05-28-2010 01:37 PM

04-14-2013, 04:15 AM	#2
chaley Grand Sorcerer Posts: 12,447 Karma: 8012886 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Calibre's search cannot do queries that require information from more than one book. The search expression can "see" only the information for the current book. This is also true of the template language. Arbitrary queries can be done in a plugin, but of course plugins requires programming. Some people have done similar things using SQL against the raw database to generate reports.

Advert