MobileRead Forums - View Single Post

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?

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?