Skip to content

Enable wildcard-searches by default #766

Open

Description

@clausjuhl

Hi Simon.

It seems that datasette currently has wildcard-searches disabled by default (along with the boolean search-options, NEAR-queries and more, and despite the docs). If I try out the search-url provided in the docs (https://fara.datasettes.com/fara/FARA_All_ShortForms?_search=manafort), it does not handle wildcard-searches, and I'm unable to make it work on my datasette-instance.

I would argue that wildcard-searches is such a standard query, that it should be enabled by default. Requiring "_searchmode=raw" when using prefix-searches seems unnecessary. Plus: What happens to non-ascii searches when using "_searchmode=raw"? Is the "escape_fts"-function from datasette.utils ignored?

Thanks!

/Claus

Activity

  1. changed the title [-]Enable prefix-searches by default[/-] [+]Enable wildcard-searches by default[/+] on May 15, 2020
  2. clausjuhl commented on Dec 9, 2020

    @clausjuhl
    Author

    Hi Simon. Any news on using wildcard-searches with datasette? Thanks!

  3. JBPressac commented on Mar 5, 2021

    @JBPressac
    Contributor

    Hello,
    I have the same wildcards search problems with an instance of Datasette. http://crbc-dataset.huma-num.fr/inventaires/fonds_auguste_dupouy_1872_1967?_search=gwerz&_sort=rowid is OK but http://crbc-dataset.huma-num.fr/inventaires/fonds_auguste_dupouy_1872_1967?_search=gwe* is not (FTS is activated on "Reference" "IntituleAnalyse" "NomDuProducteur" "PresentationDuContenu" "Notes").

    Notice that a SQL query as below launched directly from SQLite in the server's shell, retrieves results.

    select * from fonds_auguste_dupouy_1872_1967_fts where IntituleAnalyse MATCH "gwe*";

    Thanks,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions