Hello everyone! I have an issue with sorting columns by name in dashboard view.
What I have
query build with MySQL
column of type text
with utf8mb4_unicode_ci
collation
What the problem is
When I click on column header, rows are sorted by name but in case sensitive manner.
Example:
ABC
DEF
XYZ
abc
def
xyz
What I expect:
abc
ABC
def
DEF
xyz
XYZ
Is it possible to sort it on dashboard (not SQL)? Am I missing some setting?
flamber
November 18, 2019, 7:14pm
2
Hi @pawelkmpt
Can you post Diagnostic Info from Admin > Troubleshooting?
The sorting done on the dashboard tables are client-side, so it’s a javascript library in the browser - not related to database type or query.
I’ve opened an issue for you:
https://github.com/metabase/metabase/issues/11338 - upvote by clicking on the first post
{
"browser-info": {
"language": "pl",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "1.8.0_222-b10",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_222",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "25.222-b10",
"os.name": "Linux",
"os.version": "2.6.32-754.17.1.el6.x86_64",
"user.language": "en",
"user.timezone": "US/Eastern"
},
"metabase-info": {
"databases": [
"mysql",
"h2"
],
"hosting-env": "unknown",
"application-database": "h2",
"run-mode": "prod",
"version": {
"tag": "v0.33.4",
"date": "2019-10-07",
"branch": "release-0.33.x",
"hash": "9559406"
},
"settings": {
"report-timezone": null
}
}
}
flamber
November 19, 2019, 4:56pm
4
@pawelkmpt Just for your info, latest version is 0.33.5.1 and you should really migrate away from H2 as application database (metadata) in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html