"searchmode": "raw" in table metadata

[simonw]

http://localhost:8001/index/summary?_search=language%3Aeng&_sort=title&_searchmode=raw

But I'm not able to manage it in the metadata file. Here is mine (note that the sort column is taken into account)
Here it is:

{
    "databases": {
      "index": {
        "tables": {
            "summary": {
                "sort": "title",
                "searchmode": "raw"
            }
        }
      }
    }
  }

Originally posted by @Krazybug in #759 (comment)

[simonw]

This makes sense to me since other useful querystring arguments like this can be set as defaults in the metadata.json configuration.

[simonw]

Relevant documentation: https://docs.datasette.io/en/0.57.1/full_text_search.html#advanced-sqlite-search-queries

[simonw]

Relevant code:

datasette/datasette/views/table.py

Lines 491 to 498 in d23a267

	fts_pk = special_args.get("_fts_pk", table_metadata.get("fts_pk", "rowid"))
	search_args = dict(
	pair
	for pair in special_args.items()
	if pair[0].startswith("_search") and pair[0] != "_searchmode"
	)
	search = ""
	search_mode_raw = special_args.get("_searchmode") == "raw"

[simonw]

If I implement this I'll also set it up so ?_searchmode=default can be used to over-ride that and go back to the default behaviour.

[simonw]

Also came up here: #268 (comment)

[simonw]

I don't like ?_searchmode=default because it suggests "use the default" - but it actually over-rides the default that was specified by "searchmode": "raw" in metadata.json.

I'm going with ?_searchmode=escaped instead.