home / docs / sections

Menu

sections: facets:id1

This data as json

id page ref title content breadcrumbs references
facets:id1 facets id1 Facets Datasette facets can be used to add a faceted browse interface to any database table. With facets, tables are displayed along with a summary showing the most common values in specified columns. These values can be selected to further filter the table. Here's an example : Facets can be specified in two ways: using query string parameters, or in metadata.json configuration for the table. Facet queries are generated by Datasette and summarize rows the actor already has permission to view. They do not require the execute-sql permission. Use the allow_facet setting to control whether users can request facets using query string parameters. [] [{"href": "https://congress-legislators.datasettes.com/legislators/legislator_terms?_facet=type&_facet=party&_facet=state&_facet_size=10", "label": "an example"}]
Powered by Datasette · Queries took 3.75ms