Search for series with a specific number of book

wladdy · 07-02-2020, 02:46 PM

Hello,

Is there a way to search for all books in series that contain exactly n books?
With n=1, I have tried the following two syntaxes, but neither works.

series:#=1
series_index:#=1

I would appreciate a good indication on how to solve this small puzzle.

Thanks in advance! W.

ownedbycats · 07-02-2020, 02:56 PM

I don't think this is possible with any of Calibre's default options; it can't cross-reference information from different books.

Might be possible with plugins though I don't know off-hand, sorry.

BetterRed · 07-02-2020, 07:18 PM

You could do a database query for books.series_index EQ n (that's a pseudo code)

The calibre-spy plugin can do Raw SQL queries, see Index of plugins

BR

JSWolf · 07-03-2020, 09:41 AM

Here is the search that works.

Code:

series:true and series_index:<=1

07-02-2020, 02:46 PM	#1
wladdy Enthusiast Posts: 28 Karma: 10 Join Date: Oct 2010 Device: iPad / Kindle DX	Search for series with a specific number of book Hello, Is there a way to search for all books in series that contain exactly n books? With n=1, I have tried the following two syntaxes, but neither works. series:#=1 series_index:#=1 I would appreciate a good indication on how to solve this small puzzle. Thanks in advance! W.

07-03-2020, 09:41 AM	#4
JSWolf Resident Curmudgeon Posts: 73,957 Karma: 128903250 Join Date: Nov 2006 Location: Roslindale, Massachusetts Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3	Here is the search that works. Code: series:true and series_index:<=1

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Book number in a series	bbones	Barnes & Noble NOOK	4	10-11-2011 10:11 AM
search series number	Stampercam	Calibre	2	05-30-2011 02:53 AM
Series Number in Book title (Kindle)	cityzen	Library Management	7	03-20-2011 12:11 AM
Any way to show book number in series ?	alophind	Sony Reader	7	11-25-2010 11:25 AM
search for series number	speakingtohe	Calibre	4	08-29-2010 01:21 PM

07-02-2020, 02:56 PM	#2
ownedbycats Custom User Title Posts: 8,608 Karma: 61176603 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I don't think this is possible with any of Calibre's default options; it can't cross-reference information from different books. Might be possible with plugins though I don't know off-hand, sorry.

07-02-2020, 07:18 PM	#3
BetterRed null operator (he/him) Posts: 20,567 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	You could do a database query for books.series_index EQ n (that's a pseudo code) The calibre-spy plugin can do Raw SQL queries, see Index of plugins BR