issues: 275166669

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
275166669 MDU6SXNzdWUyNzUxNjY2Njk= 131 UI support for running FTS searches 9599 closed 0     3 2017-11-19T15:16:20Z 2017-11-19T17:18:05Z 2017-11-19T17:00:12Z OWNER  

Here's an example query that searches all FTS indexed columns in a table: https://sf-trees-search.now.sh/sf-trees-search-a899b92?sql=select+*+from+Street_Tree_List+where+rowid+in+%28select+rowid+from+Street_Tree_List_fts+where+Street_Tree_List_fts+match+%27grove+london+dpw%27%29%0D%0A

And here's a query that searches a specific column: https://sf-trees-search.now.sh/sf-trees-search-a899b92?sql=select+*+from+Street_Tree_List+where+rowid+in+%28select+rowid+from+Street_Tree_List_fts+where+qSpecies+match+%27london%27%29%0D%0A

If we detect that a table has FTS enabled (which we can do by looking for it as a content table reference in another FTS table's create definition) we should add a search box to the table page which constructs this query - maybe using ?_search=XXX in the query string?

<s>To support search against specified columns, we can do ?_search__ qSpecies=London.</s> - not necessary, see comment below.

  • [x] Detect if a table has a FTS index defined against it as a content= parameter
  • [x] Decide what to do if there is more than one FTS index (maybe just pick the first one?)
  • [x] Add the ?_search= query string argument
  • [x] Add the UI
 107914493 issue     
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/131/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   completed

Links from other tables