Show only first book in a series ?

[Crisis]

Hello !

I have a lot of comics and I would like a display with only the first volume of each series.
Maybe... Can be added a label browser visualization with this function :

"only the first volume of a series"

What do you think of this idea?

[DrChiper]

This comes to mind in the GUI search field:

template:"""{series_index}#@#:n:1"""

[chaley]

Originally Posted by DrChiper

This comes to mind in the GUI search field:

template:"""{series_index}#@#:n:1"""

FWIW: this does the same thing using standard calibre search syntax.

series:true and series_index:=1

It is possible that the first book in the series doesn't have index 1. This template search finds the lowest index in each series.

template:"""program:
	vals = globals(vals='');
	if !vals then
		all_series = book_values('series', 'series:true', ',', 0);
		for series in all_series:
			indices = book_values('series_index', 'series:="' & series & '"', ',', 0);
			first = 1;
			lowest = 9999999;
			for index in indices:
				if first || index <# lowest then lowest = index; first = '' fi
			rof;
			vals = list_union(vals, series & ':' & lowest, ',')
		rof;
		set_globals(vals)
	fi;
	if $series && $series_index ==# select(vals, $series) then '1' fi#@#:b:yes"""

If you use the Advanced search dialog, the template is this:

program:
	vals = globals(vals='');
	if !vals then
		all_series = book_values('series', 'series:true', ',', 0);
		for series in all_series:
			indices = book_values('series_index', 'series:="' & series & '"', ',', 0);
			first = 1;
			lowest = 9999999;
			for index in indices:
				if first || index <# lowest then lowest = index; first = '' fi
			rof;
			vals = list_union(vals, series & ':' & lowest, ',')
		rof;
		set_globals(vals)
	fi;
	if $series && $series_index ==# select(vals, $series) then '1' fi

The template search dialog is this:


EDIT: if you store the above as a saved search then you can create a virtual library showing the lowest book.

[DrChiper]

I knew you would come up with a cleverer solution

And indeed, series could have not an index of 1. My improvement would be (I like to keep code small):

series:true and series_index:"<=1"

This will find 0, 0.n and 1.

I have the impression

template:"""{series_index}#@#:n:<=1"""

is quicker, though (1 comparison less)

[chaley]

Originally Posted by DrChiper

I knew you would come up with a cleverer solution

And indeed, series could have not an index of 1. My improvement would be (I like to keep code small):

series:true and series_index:"<=1"

This will find 0, 0.n and 1.

But what if the first book is missing? The series could start with the second book (index == 2).

[Quoth]

Originally Posted by chaley

But what if the first book is missing? The series could start with the second book (index == 2).

Indeed due to special offers you might have only 14 and 20.

[theducks]

I just checked my saved searches:
I have the simple one: (index-1)
And
I also found
a LAST in series (seriously looks like chaley's work )
The reason you want formats:true is because some of us use Empty books as a wishlist

[chaley]

Originally Posted by theducks

I also found a LAST in series (seriously looks like chaley's work )

Yes. That is one of the template searches I put in the Plugboard, template, and custom composite column recipes thread. I just added the one from this thread as well, Search for books with lowest series index.

Also, the template in this thread exposed a bug in the book_values() function. It ignores values of zero. This will be fixed in the next release/preview.

[DrChiper]

Gentlemen, you are all so right
I can even add another possibility: some of my series are numbered following the preferred reading order, so series book #1 can be easily be published book #98 ... There you go.

Let's blame it on the insufficient specs from the OP which render our solutions moot at this point. As I stated before on this forum: assumptions are deadly.

On the positive side: a bug seems to be fetched and fixed due to the topic Not bad for a few minutes of our involvement.

[Quoth]

Originally Posted by theducks

The reason you want formats:true is because some of us use Empty books as a wishlist

Especially, or maybe only, when it's a series. PD or bought.

[DNSB]

Another special case is where I would want the first book in a series but there are one or more prequels which I would use series indexes such as 0.25, 0.50, 0.75 for.

[Quoth]

Originally Posted by DNSB

Another special case is where I would want the first book in a series but there are one or more prequels which I would use series indexes such as 0.25, 0.50, 0.75 for.

I do that too.