Show only series with more than x books

Deahna · 10-18-2015, 05:02 AM

This question only concerns the library view in calibre, not transfering to devices.

I'm trying to filter my library to show ALL books in the series with more than x books in it. For a start I use

Code:

series:true AND series_index:>x

but this shows me all books in the series EXCEPT those that are equal or less than x, e.g. if x =2 I get 3, 4, 5 and so on but not 1 and 2.

I'm looking for some sort of code like this SQL:

Code:

select * from library
where series in (select distinct(series) from library
                 where series_index > x)

Is there any way to translate this to calibre's syntax?

theducks · 10-18-2015, 05:36 AM

Not exactly what you asked

In the Tag browser: Use the Alter Tag Browser button (at bottom of list): Sort by: Number of books

This will group Series by how many are in each series

10-18-2015, 05:02 AM	#1
Deahna Member Posts: 15 Karma: 21264 Join Date: Jul 2014 Device: none	Show only series with more than x books This question only concerns the library view in calibre, not transfering to devices. I'm trying to filter my library to show ALL books in the series with more than x books in it. For a start I use Code: series:true AND series_index:>x but this shows me all books in the series EXCEPT those that are equal or less than x, e.g. if x =2 I get 3, 4, 5 and so on but not 1 and 2. I'm looking for some sort of code like this SQL: Code: select * from library where series in (select distinct(series) from library where series_index > x) Is there any way to translate this to calibre's syntax?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to show unsequenced series?	calvin-c	Library Management	12	02-26-2013 11:40 AM
Plugboard "Metadata: Show series [series index] - title as title (Kindle)"	Deep Cover	Library Management	6	11-30-2012 05:17 PM
Show series number but not if they aren't in a series?	M4cc45	Library Management	10	09-03-2011 07:35 PM
Any way to show book number in series ?	alophind	Sony Reader	7	11-25-2010 11:25 AM
Can't get series to show on kindle 3	major.tal	Calibre	4	10-09-2010 02:56 PM

10-18-2015, 05:36 AM	#2
theducks Well trained by Cats Posts: 31,047 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Not exactly what you asked In the Tag browser: Use the Alter Tag Browser button (at bottom of list): Sort by: Number of books This will group Series by how many are in each series

Advert