find authors with more than one book in the library

[Fynjisx]

how to write a search query to display those authors who have three or more books in the library?

[theducks]

You do know that the number next to the authors name in the Tag browser is how many entries in the Library

I highlighted entries, because that will include 'empty books'.
If you want that to only reflect those with formats, the search formats:true just before looking

[chaley]

You can do this with a template search. Open the advanced search dialog, choose the template search tab, then enter this as the template:

program:
	vals = globals(vals='');
	if !vals then
		all_authors = book_values('authors', 'authors:true', '&', 1);
		for aut in all_authors separator '&':
			if book_count('authors:="' & aut & '"', 1) >=# 3 then 
				vals = list_join('&', vals, '&', aut, '&')
			fi
		rof;
		set_globals(vals)
	fi;

	res = '';
	for aut in 'authors':
		if str_in_list(vals, '&', aut, 1, '') then
			res =  1;
			break
		fi
	rof;
	return res

The search type is number and the search value is 1.

[dunhill]

Can these searches be saved?

[chaley]

Originally Posted by dunhill

Can these searches be saved?

yes they can.

You can also save the template and reference that in a search.