docs: sections: 1 row where breadcrumbs contains "Metadata", references = "[]" and title = "Setting which columns can be used for sorting"

1 row where breadcrumbs contains "Metadata", references = "[]" and title = "Setting which columns can be used for sorting"

Search:

descending

id ▼	page	ref	title	content	breadcrumbs	references
metadata:metadata-sortable-columns	metadata	metadata-sortable-columns	Setting which columns can be used for sorting	Datasette allows any column to be used for sorting by default. If you need to control which columns are available for sorting you can do so using the optional sortable_columns key: { "databases": { "database1": { "tables": { "example_table": { "sortable_columns": [ "height", "weight" ] } } } } } This will restrict sorting of example_table to just the height and weight columns. You can also disable sorting entirely by setting "sortable_columns": [] You can use sortable_columns to enable specific sort orders for a view called name_of_view in the database my_database like so: { "databases": { "my_database": { "tables": { "name_of_view": { "sortable_columns": [ "clicks", "impressions" ] } } } } }	["Metadata"]	[]

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [sections] (
   [id] TEXT PRIMARY KEY,
   [page] TEXT,
   [ref] TEXT,
   [title] TEXT,
   [content] TEXT,
   [breadcrumbs] TEXT,
   [references] TEXT
);