Hello,
I have the following filters:
And this returns the following result:
However, there's one more item that wasn't returned which also has the same start and end date. Only difference is that rather than spanning the entire day, it starts by 2pm and ends at 4pm.
When I move the end date to 26th March, 2024. It then gets returned
This is the filter query:
WHERE "starts_at" <= COALESCE([[{{end_date}}::timestamp,]] CURRENT_DATE) AT TIME ZONE 'UTC'
AND "ends_at" >= COALESCE([[{{starts_date}}::timestamp,]] CURRENT_DATE) AT TIME ZONE 'UTC'
Does anyone have any idea what the possible issue could be? I'd appreciate any help. Thank you.
DIagnostic info:
{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KML, like Gecko) Chrome/123.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.22+7",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.22",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.22+7",
"os.name": "Linux",
"os.version": "5.10.209-198.812.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.10"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.6.0"
}
},
"run-mode": "prod",
"version": {
"date": "2024-02-22",
"tag": "v1.48.7",
"hash": "c192db1"
},
"settings": {
"report-timezone": "UTC"
}
}
}