Filter options

Get Help
1

Hello,

in an earlier Version of METABASE there was a filter option in a “numeric field” called “ends with”. (Example: 200301.01, 200301.42 - here it was possible to say ends with “.42” )

Now i have to change every question with this filter, because there was no possibility.
Is it possible to adjust this field to get this option back?

Thank you for any help!

2

Hi @EcoIngo

Please post “Diagnostic Info” from Admin > Troubleshooting, and the database type you’re querying.
And which earlier version were you able to do that with?

There has never been “Ends with” for numeric fields. I think you might have defined some special Field Type like “Category” in Admin > Data Model, which might have given you different filter options.

3

Hi flamber,

thank you for your help!

Good question :grinning: i think it was 0.33. (before you can chosse german language) Now we´re running 0.37.0.2 //

We don´t change the Database (Oracle). I have tried to change the field type in the data model, but no success until now.

4

@EcoIngo

  1. Please post “Diagnostic Info” from Admin > Troubleshooting
  2. Which version of ojdbc8.jar are you using?
5

  1. “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)”
    }

  2. the version is from 21.11.2018

6

@EcoIngo

  1. Please post the full “Diagnostic Info”.
  2. Make sure you’re using version 19.3 or newer: https://www.metabase.com/docs/latest/administration-guide/databases/oracle.html
  3. And migrate away from H2 if you’re using Metabase in production: https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
7

{
“browser-info”: {
“language”: “de-DE”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “Cp1252”,
“java.runtime.name”: “Java™ SE Runtime Environment”,
“java.runtime.version”: “10.0.2+13”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “10.0.2”,
“java.vm.name”: “Java HotSpot™ 64-Bit Server VM”,
“java.vm.version”: “10.0.2+13”,
“os.name”: “Windows Server 2012 R2”,
“os.version”: “6.3”,
“user.language”: “de”,
“user.timezone”: “Europe/Berlin”
},
“metabase-info”: {
“databases”: [
“oracle”,
“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”: “2020-11-16”,
“tag”: “v0.37.2”,
“branch”: “release-x.37.x”,
“hash”: “25e5f70”
},
“settings”: {
“report-timezone”: “Europe/Berlin”
}
}
}

8

@EcoIngo Upgrade Java - your version is EOL:
https://www.metabase.com/docs/latest/operations-guide/java-versions.html