Need case insensitive ordering by name in dashboard

Get Help
1

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:

  1. ABC
  2. DEF
  3. XYZ
  4. abc
  5. def
  6. xyz

What I expect:

  1. abc
  2. ABC
  3. def
  4. DEF
  5. xyz
  6. XYZ

Is it possible to sort it on dashboard (not SQL)? Am I missing some setting?

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 :+1: on the first post

3 
{
  "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
    }
  }
}
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