Custom field values not persisting

1

Trying to alias field values 1 and 2 to respective values of
'Veiling'
'Direct'

But the values do not persist into queries. The values are saved when I look in metabase admin, but are not applied in SQL queries.

Query:

not_persisting
not_persisting822×751 33.9 KB

Admin:

not_persisting_admin
not_persisting_admin1990×574 24.7 KB

2

Can you post Admin -> Troubleshooting -> Diagnostic Info

3 
{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/109.0",
    "vendor": ""
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "18.0.2.1+1",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "18.0.2.1",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "18.0.2.1+1",
    "os.name": "Windows 11",
    "os.version": "10.0",
    "user.language": "en",
    "user.timezone": "Europe/Amsterdam"
  },
  "metabase-info": {
    "databases": [
      "h2",
      "sqlserver"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "1.4.197 (2018-03-18)"
      },
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "1.4.197 (2018-03-18)"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2023-02-19",
      "tag": "v0.45.3",
      "branch": "release-x.45.x",
      "hash": "070f57b"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
4

Everything you do in Admin > Data Model only applies to GUI questions.
If you want to do remapping in SQL, then you have to do that manually

5

Could have sworn I had it working before, but I guess not! Thanks a bunch!

1 Like