Loosing possiblity to filter column as date

Bug reports
1

We have 2 models.
Model 2 contains date time column and i can filter that column by relative date as on screen

image
image457×606 19.9 KB

When i join Model 2 on Model 1
Model 2 is being shown as question &number& and I loose possibility to filter date time column from Model 2 as date, only as text

image
image617×546 28.9 KB

I recreated question several times, it didn`t help

running last metabase version:
{
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.21+9",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.21",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.21+9",
"os.name": "Linux",
"os.version": "5.4.0-126-generic",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.8 (Ubuntu 14.8-1.pgdg20.04+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.4"
}
},
"run-mode": "prod",
"version": {
"date": "2023-11-17",
"tag": "v0.47.8",
"branch": "?",
"hash": "639fa5e"
},
"settings": {
"report-timezone": null
}
}
}

2

I've also been having this issue since updating to 0.47.2
We're not using models but joining two questions and seeing the same inability to filter a datetime column.

1 Like
3

Thanks for your answer, at least i know that it is a common problem. Feels like we have to wait for another life quality bug fixing update :confused:

4

Has it become more fussy about data types? I'm storing a number in a varchar. Never had a problem displaying it in a gauge chart until recently. Now I need to cast it before it will work.

The pedant in me thinks this is a good thing. It was a worry at the time, though!

6

Not that I have noticed, just this particular instance with a datetime that comes from a joined question

7

Is it stored in the database as a datetime (or returned as a datetime from a view)? Is Metabase's metadata for the column correct?

8

It is stored as Datetime
In source table it is also Datetime and filter work nice
As soon as you join on top of anything, that column is being treated as text

9

Very odd. I can't replicate:
image

That was two questions, each saved as a model then a new question from those two models.
Also worked with one question joined to a saved question.

What are you joining on?

10

Hey, looks like it was fixed in last update
Checked it today with the same question, working fine
Also bug with pivot table was fixed (but nothing about it in patch release). Same here , i think

1 Like