?_facet_size=X to increase number of facets results on the page

[mroswell]

Is there a way to add a parameter to the URL to modify default_facet_size?

LIkewise, a way to produce a link on the three dots to expand to all items (or match previous number of items, or add x more)?

[simonw]

A URL parameter to modify that facet size is a really good idea.

I thought I had an issue open for "..." linking to more results but I can't find it now.

[simonw]

?_facet_size=50 seems like a very reasonable thing to support - I'll cap it at whatever the max_returned_rows setting is (which defaults to 1000).

[simonw]

Here's the code in question:

datasette/datasette/facets.py

Lines 187 to 210 in 5e9672c

	qs_pairs = self.get_querystring_pairs()
	facet_size = self.ds.setting("default_facet_size")
	for source_and_config in self.get_configs():
	config = source_and_config["config"]
	source = source_and_config["source"]
	column = config.get("column") or config["simple"]
	facet_sql = """
	select {col} as value, count(*) as count from (
	{sql}
	)
	where {col} is not null
	group by {col} order by count desc, value limit {limit}
	""".format(
	col=escape_sqlite(column), sql=self.sql, limit=facet_size + 1
	)
	try:
	facet_rows_results = await self.ds.execute(
	self.database,
	facet_sql,
	self.params,
	truncate=False,
	custom_time_limit=self.ds.setting("facet_time_limit_ms"),
	)

It has access to the current request object as self.request.

[simonw]

Documentation:

• https://docs.datasette.io/en/latest/facets.html#facets-in-query-strings at the bottom of the section
• https://docs.datasette.io/en/latest/json_api.html#special-table-arguments at the bottom of the list of arguments

[simonw]

Added ?_facet_size=max in #1337 and made the ... truncated note link to that - here's a demo: https://fivethirtyeight.datasettes.com/fivethirtyeight/antiquities-act%2Factions_under_antiquities_act?_facet=states&_facet=current_agency&_facet=pres_or_congress