Metabase text filters not working on MongoDB config

Get Help
1

Hi there, we recently updated to the latest available version of Metabase on docker but we faced an issue as stated below.

  1. The metrics fail to load as seen below with text based filter.

image
image1888×572 15.8 KB

  1. We tried accessing metric from the dashboard individually but it throws an error as seen below.

image
image1895×929 31.8 KB

  1. If we access the metric from the search bar it loads just fine as seen below.

image
image1909×930 79.7 KB

  1. My code for text based filter in the match clause.

{[[ "countryCode": {"$eq": {{country_code}} } ]]},

Diagnostic info:

{
  "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/106.0.0.0 Safari/537.36 Edg/106.0.1370.52",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.16.1+1",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.16.1",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.16.1+1",
    "os.name": "Linux",
    "os.version": "4.15.0-1065-aws",
    "user.language": "en",
    "user.timezone": "Asia/Riyadh"
  },
  "metabase-info": {
    "databases": [
      "mongo"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "12.11"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.5.0"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2022-10-17",
      "tag": "v0.44.5",
      "branch": "release-x.44.x",
      "hash": "29fab4d"
    },
    "settings": {
      "report-timezone": "Asia/Kuwait"
    }
  }
}
2

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

1 Like
3

Any ETA on this fix? All of our dashboards and 400+ metrics/questions use text based country filter and its really hurting us :expressionless:

4

@shahmirali I cannot provide timelines on issues. There are 600+ other bugs. Try using a Field Filter instead: https://www.metabase.com/docs/latest/questions/native-editor/sql-parameters#the-field-filter-variable-type

5

So we should go on and change it to Field filter for 400+ metrics :+1:

6

Well, I found a hack for this. " Load dashboards/questions directly from the search bar".