Date Filter click behaviour problems

mmoole · July 26, 2024, 1:44pm

strangely I cannot get click behaviour to filter by dates as doing directly click in date filter.
Here ist the date filter click baheaviour

Which uses the date of products table

The date filter is setup like so:

But clicking on the question data point
2024-07-26 15_29_46 001237 click

... results in broken dashboard results
2024-07-26 15_36_00 001239 click result

The log reads that:
ERRORmetabase.query-processor.middleware.catch-exceptions - Error processing query: Don't know how to parse date string "2023-11-01T00:00:00.000Z"

DETAILS LOG

2024-07-26 13:31:45,234 [clojure-agent-send-off-pool-219] ERRORmetabase.query-processor.middleware.catch-exceptions - Error processing query: Don't know how to parse date string "2023-11-01T00:00:00.000Z"
{:database_id 1,
 :started_at #t "2024-07-26T13:31:45.218197500Z[Etc/UTC]",
 :action_id nil,
 :error_type :invalid-parameter,
 :json_query
 {:constraints {:max-results 10000, :max-results-bare-rows 2000},
  :type :query,
  :middleware {:js-int-to-string? true, :ignore-cached-results? false},
  :viz-settings
  {:click_behavior
   {:type "crossfilter",
    :parameterMapping
    {:ee5b094d
     {:source {:type "column", :id "CREATED_AT", :name "Created At"},
      :target {:type "parameter", :id "ee5b094d"},
      :id "ee5b094d"}}}},
  :database 1,
  :query
  {:source-table 1,
   :aggregation [[:count]],
   :breakout [[:field 7 {:base-type :type/DateTime, :temporal-unit :month}] [:field 4 {:base-type :type/Text}]]},
  :parameters
  [{:type :string/=, :id "36732564", :target [:dimension [:field 4 {:base-type :type/Text}]]}
   {:type :date/all-options,
    :value "2023-11-01T00:00:00.000Z",
    :id "ee5b094d",
    :target [:dimension [:field 7 {:base-type :type/DateTime}]]}],
  :async? true,
  :cache-ttl 140},
 :native nil,
 :status :failed,
 :class clojure.lang.ExceptionInfo,
 :stacktrace
 ["--> driver.common.parameters.dates$date_string__GT_filter.invokeStatic(dates.clj:476)"
  "driver.common.parameters.dates$date_string__GT_filter.invoke(dates.clj:470)"
  "query_processor.middleware.parameters.mbql$build_filter_clause.invokeStatic(mbql.clj:75)"
  "query_processor.middleware.parameters.mbql$build_filter_clause.invoke(mbql.clj:62)"
  "query_processor.middleware.parameters.mbql$expand.invokeStatic(mbql.clj:105)"
  "query_processor.middleware.parameters.mbql$expand.invoke(mbql.clj:91)"
  "query_processor.middleware.parameters$expand_mbql_params.invokeStatic(parameters.clj:37)"
  "query_processor.middleware.parameters$expand_mbql_params.invoke(parameters.clj:33)"
  "query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:49)"
  "query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
  "query_processor.middleware.parameters$expand_all$replace_71724__71725.invoke(parameters.clj:59)"
  "mbql.util.match.impl$replace_in_collection$iter__29469__29473$fn__29474.invoke(impl.cljc:45)"
  "mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:44)"
  "mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:39)"
  "query_processor.middleware.parameters$expand_all$replace_71724__71725.invoke(parameters.clj:59)"
  "query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
  "query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
  "query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
  "query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
  "query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:83)"
  "query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:79)"
  "query_processor.middleware.parameters$substitute_parameters_STAR_.invokeStatic(parameters.clj:88)"
  "query_processor.middleware.parameters$substitute_parameters_STAR_.invoke(parameters.clj:85)"
  "query_processor.middleware.parameters$substitute_parameters.invokeStatic(parameters.clj:115)"
  "query_processor.middleware.parameters$substitute_parameters.invoke(parameters.clj:107)"
  "query_processor$preprocess_STAR_$fn__73816.invoke(query_processor.clj:164)"
  "query_processor$preprocess_STAR_.invokeStatic(query_processor.clj:162)"
  "query_processor$preprocess_STAR_.invoke(query_processor.clj:157)"
  "query_processor$fn__73824$combined_pre_process__73825$combined_pre_process_STAR___73826.invoke(query_processor.clj:259)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__67100.invoke(fetch_source_query.clj:303)"
  "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__72567$fn__72571.invoke(resolve_database_and_driver.clj:77)"
  "driver$do_with_driver.invokeStatic(driver.clj:97)"
  "driver$do_with_driver.invoke(driver.clj:92)"
  "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__72567.invoke(resolve_database_and_driver.clj:76)"
  "query_processor.middleware.store$initialize_store$fn__67727$fn__67728.invoke(store.clj:14)"
  "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)"
  "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
  "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)"
  "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
  "query_processor.middleware.store$initialize_store$fn__67727.invoke(store.clj:13)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database$fn__72564.invoke(resolve_database_and_driver.clj:60)"
  "query_processor.middleware.normalize_query$normalize$fn__72869.invoke(normalize_query.clj:38)"
  "query_processor.middleware.enterprise$fn__72504$handle_audit_app_internal_queries__72505$fn__72507.invoke(enterprise.clj:96)"
  "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__72515.invoke(enterprise.clj:103)"
  "query_processor.middleware.constraints$mark_needs_default_userland_constraints$fn__71630.invoke(constraints.clj:104)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__72800.invoke(process_userland_query.clj:156)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__73401.invoke(catch_exceptions.clj:171)"
  "query_processor.reducible$async_qp$qp_STAR___63219$thunk__63221.invoke(reducible.clj:126)"
  "query_processor.reducible$async_qp$qp_STAR___63219$fn__63223.invoke(reducible.clj:131)"],
 :card_id 195,
 :context :dashboard,
 :error "Don't know how to parse date string \"2023-11-01T00:00:00.000Z\"",
 :row_count 0,
 :running_time 0,
 :preprocessed nil,
 :ex-data {:type :invalid-parameter, :date-string "2023-11-01T00:00:00.000Z"},
 :data {:rows [], :cols []}}

tring "2023-11-01T00:00:00.000Z"
{:database_id 1,
 :started_at #t "2024-07-26T13:31:45.250260800Z[Etc/UTC]",
 :action_id nil,
 :error_type :invalid-parameter,
 :json_query
 {:constraints {:max-results 10000, :max-results-bare-rows 2000},
  :type :query,
  :middleware {:js-int-to-string? true, :ignore-cached-results? false},
  :viz-settings {},
  :database 1,
  :query
  {:source-table 1,
   :order-by [[:asc [:field 8 {:base-type :type/BigInteger}]] [:asc [:field 5 {:base-type :type/Text}]]]},
  :parameters
  [{:type :string/=, :id "36732564", :target [:dimension [:field 4 {:base-type :type/Text}]]}
   {:type :date/all-options,
    :value "2023-11-01T00:00:00.000Z",
    :id "ee5b094d",
    :target [:dimension [:field 7 {:base-type :type/DateTime}]]}],
  :async? true,
  :cache-ttl 100},
 :native nil,
 :status :failed,
 :class clojure.lang.ExceptionInfo,
 :stacktrace
 ["--> driver.common.parameters.dates$date_string__GT_filter.invokeStatic(dates.clj:476)"
  "driver.common.parameters.dates$date_string__GT_filter.invoke(dates.clj:470)"
  "query_processor.middleware.parameters.mbql$build_filter_clause.invokeStatic(mbql.clj:75)"
  "query_processor.middleware.parameters.mbql$build_filter_clause.invoke(mbql.clj:62)"
  "query_processor.middleware.parameters.mbql$expand.invokeStatic(mbql.clj:105)"
  "query_processor.middleware.parameters.mbql$expand.invoke(mbql.clj:91)"
  "query_processor.middleware.parameters$expand_mbql_params.invokeStatic(parameters.clj:37)"
  "query_processor.middleware.parameters$expand_mbql_params.invoke(parameters.clj:33)"
  "query_processor.middleware.parameters$expand_one.invokeStatic(parameters.clj:49)"
  "query_processor.middleware.parameters$expand_one.invoke(parameters.clj:41)"
  "query_processor.middleware.parameters$expand_all$replace_71724__71725.invoke(parameters.clj:59)"
  "mbql.util.match.impl$replace_in_collection$iter__29469__29473$fn__29474.invoke(impl.cljc:45)"
  "mbql.util.match.impl$replace_in_collection.invokeStatic(impl.cljc:44)"
  "mbql.util.match.impl$replace_in_collection.invoke(impl.cljc:39)"
  "query_processor.middleware.parameters$expand_all$replace_71724__71725.invoke(parameters.clj:59)"
  "query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:59)"
  "query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
  "query_processor.middleware.parameters$expand_all.invokeStatic(parameters.clj:56)"
  "query_processor.middleware.parameters$expand_all.invoke(parameters.clj:53)"
  "query_processor.middleware.parameters$expand_parameters.invokeStatic(parameters.clj:83)"
  "query_processor.middleware.parameters$expand_parameters.invoke(parameters.clj:79)"
  "query_processor.middleware.parameters$substitute_parameters_STAR_.invokeStatic(parameters.clj:88)"
  "query_processor.middleware.parameters$substitute_parameters_STAR_.invoke(parameters.clj:85)"
  "query_processor.middleware.parameters$substitute_parameters.invokeStatic(parameters.clj:115)"
  "query_processor.middleware.parameters$substitute_parameters.invoke(parameters.clj:107)"
  "query_processor$preprocess_STAR_$fn__73816.invoke(query_processor.clj:164)"
  "query_processor$preprocess_STAR_.invokeStatic(query_processor.clj:162)"
  "query_processor$preprocess_STAR_.invoke(query_processor.clj:157)"
  "query_processor$fn__73824$combined_pre_process__73825$combined_pre_process_STAR___73826.invoke(query_processor.clj:259)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__67100.invoke(fetch_source_query.clj:303)"
  "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__72567$fn__72571.invoke(resolve_database_and_driver.clj:77)"
  "driver$do_with_driver.invokeStatic(driver.clj:97)"
  "driver$do_with_driver.invoke(driver.clj:92)"
  "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__72567.invoke(resolve_database_and_driver.clj:76)"
  "query_processor.middleware.store$initialize_store$fn__67727$fn__67728.invoke(store.clj:14)"
  "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)"
  "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
  "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)"
  "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
  "query_processor.middleware.store$initialize_store$fn__67727.invoke(store.clj:13)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database$fn__72564.invoke(resolve_database_and_driver.clj:60)"
  "query_processor.middleware.normalize_query$normalize$fn__72869.invoke(normalize_query.clj:38)"
  "query_processor.middleware.enterprise$fn__72504$handle_audit_app_internal_queries__72505$fn__72507.invoke(enterprise.clj:96)"
  "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__72515.invoke(enterprise.clj:103)"
  "query_processor.middleware.constraints$mark_needs_default_userland_constraints$fn__71630.invoke(constraints.clj:104)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__72800.invoke(process_userland_query.clj:156)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__73401.invoke(catch_exceptions.clj:171)"
  "query_processor.reducible$async_qp$qp_STAR___63219$thunk__63221.invoke(reducible.clj:126)"
  "query_processor.reducible$async_qp$qp_STAR___63219$fn__63223.invoke(reducible.clj:131)"],
 :card_id 197,
 :context :dashboard,
 :error "Don't know how to parse date string \"2023-11-01T00:00:00.000Z\"",
 :row_count 0,
 :running_time 0,
 :preprocessed nil,
 :ex-data {:type :invalid-parameter, :date-string "2023-11-01T00:00:00.000Z"},
 :data {:rows [], :cols []}}

which seems strange since directly usign the filter at the top of the dashboard does work for filtering created date

I replicated this using the demo database, but I get the same error message when using it on production MSSQL using version Metabase 0.49.21 .
What could I do better in order to make click behaviour also working to filter by date?
Or did I just find a bug there?

greetings

o.poda · December 1, 2025, 11:43am

@mmoole have you solved this issue?

mmoole · December 17, 2025, 10:21am

I must admit I cannot reproduce it today because this test environment is no more

system · December 20, 2025, 10:21am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.