Date Filter "On" not working


#1

Hi all,

I’m using Metabase 0.31.2 pointing to a Redshift database, and I am having an issue with the date filter, specifically, the “On” option where you select a single date. All of the other options (Previous, Next, Before, After, Between, etc…) work great. However when I choose the “On” option for my report, I get a message saying “There was a problem displaying this chart.”

There are no errors in the Javascript console on my browser, but I do see this seemingly relevant error in the logs:

02-13 00:15:04 e[1mWARN metabase.query-processore[0m :: e[31mQuery failure: Must be a valid instance of one of these clauses: :and, :or, :not, :=, :!=, :<, :>, :<=, :>=, :between, :starts-with, :ends-with, :contains, :does-not-contain, :inside, :is-null, :not-null, :time-interval, :segment
("clojure.core$ex_info.invokeStatic(core.clj:4739)"
 "clojure.core$ex_info.invoke(core.clj:4739)"
 "--> query_processor$assert_query_status_successful.invokeStatic(query_processor.clj:285)"
 "query_processor$assert_query_status_successful.invoke(query_processor.clj:277)"
 "query_processor$run_and_save_query_BANG_.invokeStatic(query_processor.clj:323)"
 "query_processor$run_and_save_query_BANG_.invoke(query_processor.clj:316)"
 "query_processor$fn__37732$process_query_and_save_execution_BANG___37737$fn__37738.invoke(query_processor.clj:354)"
 "query_processor$fn__37732$process_query_and_save_execution_BANG___37737.invoke(query_processor.clj:340)"
 "api.card$run_query_for_card.invokeStatic(card.clj:580)"
 "api.card$run_query_for_card.doInvoke(card.clj:566)"
 "api.card$fn__47036$fn__47039.invoke(card.clj:587)"
 "api.card$fn__47036.invokeStatic(card.clj:586)"
 "api.card$fn__47036.invoke(card.clj:582)"

Any idea what’s going on? I did look in GitHub issues, but didn’t see anything quite like this.

Thanks in advance!
Joe


#2

Hi @JZee
I’m pretty sure you’re seeing this issue:
https://github.com/metabase/metabase/issues/9090


#3

Yup. That looks like exactly what I’m seeing. Thanks for helping me find it!