Selecting the highest Series_Index ?

[rolgiati]

I am trying to update my library, to check that I have the latest(s) book(s) in each of the Series I have been reading.

Is there a way, for all the Series in a library, to selet only the books with the highest Series_Index of each Series ?

[JSWolf]

Sort by series and then you can scroll to see which books are the highest number easily.

[chaley]

Originally Posted by rolgiati

I am trying to update my library, to check that I have the latest(s) book(s) in each of the Series I have been reading.

Is there a way, for all the Series in a library, to selet only the books with the highest Series_Index of each Series ?

You can do that with a template search that finds all series, finds the book(s) with highest index, then shows those books. This one works for me.

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;
			highest = 0;
			for index in indices:
				if first || index ># highest then highest = index; first = '' fi
			rof;
			vals = list_union(vals, series & ':' & highest, ',')
		rof;
		set_globals(vals)
	fi;
	if $series && $series_index ==# select(vals, $series) then '1' fi#@#:n:1"""

If you use the Advanced search builder in the search bar then 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;
			highest = 0;
			for index in indices:
				if first || index ># highest then highest = index; first = '' fi
			rof;
			vals = list_union(vals, series & ':' & highest, ',')
		rof;
		set_globals(vals)
	fi;
	if $series && $series_index ==# select(vals, $series) then '1' fi

The Comparison type is Number and the Template value is 1

[theducks]

The Quality check plugin looks for Gaps (thus it must find the highest present)

[capink]

Since this is an old thread that predates the introduction of python templates by chaley, here is the python equivalent for the chaley's GPM template:

python:
def evaluate(book, context):
    vals = context.globals.get('highest_index_ids')
    if not vals:
        vals = context.globals['highest_index_ids'] = []
        db = context.db
        cats = db.new_api.get_categories(book_ids=None)
        all_series = [ t.name for t in cats['series'] ]
        for series in all_series:
            book_ids = db.data.search_getting_ids(f'series:"={series}"', '')
            indices = {}
            for book_id in book_ids:
                idx = db.new_api.field_for('series_index', book_id)
                indices[idx] = book_id
            vals.append(indices[max(indices.keys())])
    return '1' if book.id in vals else '0'

This should be a little faster.