Column Filter does not show all possible values

Bug reports
1

As you can see in attached screenshots, this column has many "DE013" values, but "DE013" does not show up when filtering the column. This is causing a lot of problems for me at the moment.
I have tried everything, from syncing the database anew to turning the question into a model.
It is a categorical column with 15 possible values.

one
one2880×1574 505 KB

two
two1920×1055 113 KB

2

You haven’t posted diagnostic info

3

Is this right?

{
"browser-info": {
"language": "de-DE",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36",
"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": "5.15.0-1027-gcp",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"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": "2022-09-29",
"tag": "v0.44.4",
"branch": "release-x.44.x",
"hash": "382d728"
},
"settings": {
"report-timezone": null
}
}
}

4

Any Update on this?

5

Yes, please upgrade to the latest version (45.2.1) and let us know if this changes anything.

By the way, you're using H2 as the app db. That app db will corrupt eventually and you'll lose all your work, you need to get away from H2 ASAP Migrating to a production application database

6

Thank you! And yes, will switch ASAP