Category filter suggestions not showing up when typing and search is not good

Hi,

Recently metabase has been deployed to the entire company and I have been running across these complaints:

  1. If a category field has many unique values (the column I usually look at has over 500 unique varchar values). When I start typing, I do not see any suggestions show up. How can I fix this?

  2. The search function on a category filter is very poor, it does not allow for case insensitive searches and wildcard searches. If possible I would like if we could get a checkbox when we want it to be case sensitive. Basically a fuzzy search on all searchables.

Thanks,
Vinayak

edit: just found an open issue #14337 for fuzzy search but its only a request for global search.

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.7+10",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.7",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.7+10",
    "os.name": "Linux",
    "os.version": "4.14.193-149.317.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "h2",
      "redshift"
    ],
    "hosting-env": "elastic-beanstalk",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.8"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.8"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2020-12-03",
      "tag": "v0.37.3",
      "branch": "release-x.37.x",
      "hash": "2f1e783"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

Hi @VinayakK
You are seeing this issue:
https://github.com/metabase/metabase/issues/7603 - upvote by clicking :+1: on the first post

There are other issues open specifically for contains:
https://github.com/metabase/metabase/issues/8219
https://github.com/metabase/metabase/issues/11682

I got the search box selected on all similarly large tables/columns and I have upvoted for the features.

Thank you!