Filter issue

varnika · October 10, 2022, 12:39pm

I have added a filter (text and category) in my Dashboard. In this filter I have included user_id which shown in screenshort second. But this filter is not working.

I have done this because some of my questions build in native queries and converted into model. When I have taken filter (ID) then it will not working on these question. i.e only work on direct question build in metabase.

Please suggest a solution for that. Either (text and category) filter should work OR (ID) filter should work with native question also which I already converted into models.

flamber · October 10, 2022, 12:45pm

Hi @varnika

Post "Diagnostic Info" from Admin > Troubleshooting.
Include the full stacktrace from Admin > Troubleshooting > Logs, when you are seeing errors.

varnika · October 10, 2022, 1:03pm

Apology for not posted Diagnostic Info.

{
"browser-info": {
"language": "en-GB",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.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.16+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.16",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.16+8",
"os.name": "Linux",
"os.version": "5.4.0-1083-aws",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"mongo",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.8"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.4.1"
}
},
"run-mode": "prod",
"version": {
"date": "2022-08-16",
"tag": "v0.44.1",
"branch": "release-x.44.x",
"hash": "112f5aa"
},
"settings": {
"report-timezone": "Asia/Calcutta"
}
}
}

What should Exactly you want form logs? because it is too large, I am confused what should I share exactly.

flamber · October 10, 2022, 1:23pm

@varnika Here's the trick. Open troubleshooting in one tab, scroll all the way to the bottom, then reproduce the error in another tab, go back to your troubleshooting tab, which then has a big stacktrace if you scroll down. Yes, stacktraces are big, as you can see if you look in other topics in this forum.

varnika · October 10, 2022, 1:48pm

[cbc229df-87f7-4335-8edd-8f6f9798f84c] 2022-10-10T19:03:33+05:30 DEBUG metabase.server.middleware.log POST /api/dashboard/24/dashcard/324/card/446/query 202 [ASYNC: completed] 1.1 s (46 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (10 idle, 0 queued) (185 total active threads) Queries in flight: 4 (0 queued)
[cbc229df-87f7-4335-8edd-8f6f9798f84c] 2022-10-10T19:03:33+05:30 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: UUID string too large
{:database_id 21,
:started_at #t "2022-10-10T13:33:33.163678Z[GMT]",
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:database 21,
:query
{:aggregation [[:count]],
:joins
[{:alias "users",
:condition [:= [:field "user_id" {:base-type :type/UUID}] [:field 3352 {:join-alias "users"}]],
:fields :all,
:source-table 288}],
:source-table "card__459",
:breakout [[:field "created_date" {:temporal-unit :week, :base-type :type/DateTime}]]},
:parameters
[{:type :string/contains,
:value ["6f139768-65ca-4532-a3ce-f9bf2ddfa481"],
:target [:dimension [:field 3352 {:join-alias "users"}]],
:options {:case-sensitive false},
:id "f8ae319d"}],
:async? true,
:cache-ttl 2},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["java.base/java.util.UUID.fromString(Unknown Source)"
"--> driver.postgres$fn__60454.invokeStatic(postgres.clj:277)"
"driver.postgres$fn__60454.invoke(postgres.clj:271)"
"driver.sql.query_processor$like_clause.invokeStatic(query_processor.clj:689)"
"driver.sql.query_processor$like_clause.invoke(query_processor.clj:678)"
"driver.sql.query_processor$fn__47061.invokeStatic(query_processor.clj:701)"
"driver.sql.query_processor$fn__47061.invoke(query_processor.clj:699)"
"driver.sql.query_processor$fn__47156.invokeStatic(query_processor.clj:768)"
"driver.sql.query_processor$fn__47156.invoke(query_processor.clj:766)"
"driver.sql.query_processor$apply_top_level_clauses$fn__47263.invoke(query_processor.clj:931)"
"driver.sql.query_processor$apply_top_level_clauses.invokeStatic(query_processor.clj:929)"
"driver.sql.query_processor$apply_top_level_clauses.invoke(query_processor.clj:925)"
"driver.sql.query_processor$apply_clauses.invokeStatic(query_processor.clj:955)"
"driver.sql.query_processor$apply_clauses.invoke(query_processor.clj:949)"
"driver.sql.query_processor$mbql__GT_honeysql.invokeStatic(query_processor.clj:978)"
"driver.sql.query_processor$mbql__GT_honeysql.invoke(query_processor.clj:973)"
"driver.sql.query_processor$mbql__GT_native.invokeStatic(query_processor.clj:987)"
"driver.sql.query_processor$mbql__GT_native.invoke(query_processor.clj:983)"
"driver.sql$fn__81669.invokeStatic(sql.clj:40)"
"driver.sql$fn__81669.invoke(sql.clj:38)"
"query_processor.middleware.mbql_to_native$query__GT_native_form.invokeStatic(mbql_to_native.clj:13)"
"query_processor.middleware.mbql_to_native$query__GT_native_form.invoke(mbql_to_native.clj:8)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51552.invoke(mbql_to_native.clj:20)"
"query_processor$fn__54083$combined_post_process__54088$combined_post_process_STAR___54089.invoke(query_processor.clj:211)"
"query_processor$fn__54083$combined_pre_process__54084$combined_pre_process_STAR___54085.invoke(query_processor.clj:208)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52528$fn__52533.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52528.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48563.invoke(fetch_source_query.clj:342)"
"query_processor.middleware.store$initialize_store$fn__48751$fn__48752.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__48751.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52800.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49833.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52739.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53111.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44972$thunk__44974.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44972$fn__44976.invoke(reducible.clj:105)"],
:card_id 464,
:context :dashboard,
:error "UUID string too large",
:row_count 0,
:running_time 0,
:preprocessed
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:user-parameters
[{:type :string/contains,
:value ["6f139768-65ca-4532-a3ce-f9bf2ddfa481"],
:target [:dimension [:field 3352 {:join-alias "users"}]],
:options {:case-sensitive false},
:id "f8ae319d"}],
:info {:executed-by 1, :context :dashboard, :card-id 464, :card-name "Feedback not given", :dashboard-id 24},
:database 21,
:query
{:source-query
{:native
"select n.created_at, n.person_id, m.message,n.created_date,n.deleted_at, m.user_id\nfrom (select date_trunc('day', CAST("triggers"."created_at" AS timestamp)) as created_date,feedbacks.created_at,triggers.person_id,feedbacks.message, triggers.deleted_at,feedbacks.user_id from triggers left outer join feedbacks on feedbacks.trigger_id = triggers.id order by triggers.id) m \nright outer join (select max(t.created_at) as created_at,t.person_id , t.deleted_at, t.created_date\nfrom (select date_trunc('day', CAST("triggers"."created_at" AS timestamp)) as created_date,feedbacks.created_at,triggers.person_id,feedbacks.message , triggers.deleted_at,feedbacks.user_id from triggers left outer join feedbacks on feedbacks.trigger_id = triggers.id order by triggers.id) t group by t.created_date,t.person_id , t.deleted_at) n\non m.created_at=n.created_at and m.person_id=n.person_id\nWHERE n.deleted_at is null and n.created_at is null\ngroup by n.created_at, n.person_id, m.message,n.created_date,n.deleted_at,m.user_id\norder by created_date"},
:joins
[{:alias "users",
:strategy :left-join,
:condition [:= [:field "user_id" {:base-type :type/UUID}] [:field 3352 {:join-alias "users"}]],
:fields
[[:field 3352 {:join-alias "users"}]
[:field 3347 {:join-alias "users"}]
[:field 3355 {:join-alias "users"}]
[:field 3350 {:join-alias "users"}]
[:field 3354 {:join-alias "users"}]
[:field 3349 {:join-alias "users"}]
[:field 3353 {:join-alias "users"}]
[:field 3346 {:join-alias "users"}]
[:field 3345 {:join-alias "users"}]
[:field 3348 {:join-alias "users"}]
[:field 3351 {:temporal-unit :default, :join-alias "users"}]
[:field 3344 {:temporal-unit :default, :join-alias "users"}]],
:source-table 288}],
:source-metadata
[{:display_name "created_at",
:field_ref [:field "created_at" {:base-type :type/DateTimeWithLocalTZ, :temporal-unit :default}],
:name "created_at",
:base_type :type/DateTimeWithLocalTZ,
:effective_type :type/DateTimeWithLocalTZ,
:semantic_type :type/CreationTimestamp,
:fingerprint {:global {:distinct-count 1, :nil% 1}, :type {:type/DateTime {:earliest nil, :latest nil}}}}
{:display_name "person_id",
:field_ref [:field "person_id" {:base-type :type/UUID}],
:name "person_id",
:base_type :type/UUID,
:effective_type :type/UUID,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 132, :nil% 0},
:type {:type/Text {:percent-json 0, :percent-url 0, :percent-email 0, :percent-state 0, :average-length 36}}}}
{:display_name "message",
:field_ref [:field "message" {:base-type :type/Text}],
:name "message",
:base_type :type/Text,
:effective_type :type/Text,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 1},
:type {:type/Text {:percent-json 0, :percent-url 0, :percent-email 0, :percent-state 0, :average-length 0}}}}
{:display_name "created_date",
:field_ref [:field "created_date" {:base-type :type/DateTime, :temporal-unit :default}],
:name "created_date",
:base_type :type/DateTime,
:effective_type :type/DateTime,
:semantic_type :type/CreationTimestamp,
:fingerprint
{:global {:distinct-count 35, :nil% 0},
:type {:type/DateTime {:earliest "2022-07-26T00:00:00+05:30", :latest "2022-09-28T00:00:00+05:30"}}}}
{:display_name "deleted_at",
:field_ref [:field "deleted_at" {:base-type :type/DateTimeWithLocalTZ, :temporal-unit :default}],
:name "deleted_at",
:base_type :type/DateTimeWithLocalTZ,
:effective_type :type/DateTimeWithLocalTZ,
:semantic_type :type/DeletionTimestamp,
:fingerprint {:global {:distinct-count 1, :nil% 1}, :type {:type/DateTime {:earliest nil, :latest nil}}}}
{:display_name "user_id",
:field_ref [:field "user_id" {:base-type :type/UUID}],
:name "user_id",
:base_type :type/UUID,
:effective_type :type/UUID,
:semantic_type nil,
:fingerprint
{:global {:distinct-count 1, :nil% 1},
:type {:type/Text {:percent-json 0, :percent-url 0, :percent-email 0, :percent-state 0, :average-length 0}}}}],
:source-query/dataset? true,
:filter
[:contains
[:field 3352 {:join-alias "users"}]
[:value
"6f139768-65ca-4532-a3ce-f9bf2ddfa481"
{:base_type :type/UUID,
:effective_type :type/UUID,
:coercion_strategy nil,
:semantic_type :type/PK,
:database_type "uuid",
:name "id"}]
{:case-sensitive false}],
:source-card-id 459,
:breakout [[:field "created_date" {:temporal-unit :week, :base-type :type/DateTime}]],
:order-by [[:asc [:field "created_date" {:temporal-unit :week, :base-type :type/DateTime}]]],
:aggregation [[:aggregation-options [:count] {:name "count"}]]},
:async? true,
:cache-ttl 2},
:data {:rows [], :cols []}}

[cbc229df-87f7-4335-8edd-8f6f9798f84c] 2022-10-10T19:03:33+05:30 DEBUG metabase.server.middleware.log POST /api/dashboard/24/dashcard/333/card/464/query 202 [ASYNC: completed] 1.1 s (35 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (10 idle, 0 queued) (185 total active threads) Queries in flight: 3 (0 queued)
[cbc229df-87f7-4335-8edd-8f6f9798f84c] 2022-10-10T19:03:33+05:30 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: UUID string too large
{:database_id 21,
:started_at #t "2022-10-10T13:33:33.054943Z[GMT]",
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:database 21,
:query
{:source-table 330,
:joins
[{:fields :all,
:source-table 317,
:condition [:= [:field 3777 nil] [:field 3641 {:join-alias "person_detail"}]],
:alias "person_detail"}
{:fields :all,
:source-table 329,
:condition [:= [:field 3777 nil] [:field 3766 {:join-alias "person_poi_user_mapping"}]],
:alias "person_poi_user_mapping",
:strategy :left-join}
{:fields :all,
:source-table 288,
:condition [:= [:field 3767 {:join-alias "person_poi_user_mapping"}] [:field 3352 {:join-alias "users"}]],
:alias "users",
:strategy :left-join}],
:filter
[:and
[:= [:field 3663 {:join-alias "person_detail"}] true]
[:time-interval [:field 3776 nil] :current :day {:include-current true}]],
:aggregation [[:distinct [:field 3777 nil]]],
:breakout [[:field 3776 {:temporal-unit :day}]]},
:parameters
[{:type :string/contains,
:value ["6f139768-65ca-4532-a3ce-f9bf2ddfa481"],
:target [:dimension [:field 3767 {:join-alias "person_poi_user_mapping"}]],
:options {:case-sensitive false},
:id "f8ae319d"}],
:async? true,
:cache-ttl 3},
:native nil,
:status :failed,
:class java.lang.IllegalArgumentException,
:stacktrace
["java.base/java.util.UUID.fromString(Unknown Source)"
"--> driver.postgres$fn__60454.invokeStatic(postgres.clj:277)"
"driver.postgres$fn__60454.invoke(postgres.clj:271)"
"driver.sql.query_processor$like_clause.invokeStatic(query_processor.clj:689)"
"driver.sql.query_processor$like_clause.invoke(query_processor.clj:678)"
"driver.sql.query_processor$fn__47061.invokeStatic(query_processor.clj:701)"
"driver.sql.query_processor$fn__47061.invoke(query_processor.clj:699)"
"driver.sql.query_processor$fn__47138.invokeStatic(query_processor.clj:751)"
"driver.sql.query_processor$fn__47138.invoke(query_processor.clj:749)"
"driver.sql.query_processor$fn__47156.invokeStatic(query_processor.clj:768)"
"driver.sql.query_processor$fn__47156.invoke(query_processor.clj:766)"
"driver.sql.query_processor$apply_top_level_clauses$fn__47263.invoke(query_processor.clj:931)"
"driver.sql.query_processor$apply_top_level_clauses.invokeStatic(query_processor.clj:929)"
"driver.sql.query_processor$apply_top_level_clauses.invoke(query_processor.clj:925)"
"driver.sql.query_processor$apply_clauses.invokeStatic(query_processor.clj:959)"
"driver.sql.query_processor$apply_clauses.invoke(query_processor.clj:949)"
"driver.sql.query_processor$mbql__GT_honeysql.invokeStatic(query_processor.clj:978)"
"driver.sql.query_processor$mbql__GT_honeysql.invoke(query_processor.clj:973)"
"driver.sql.query_processor$mbql__GT_native.invokeStatic(query_processor.clj:987)"
"driver.sql.query_processor$mbql__GT_native.invoke(query_processor.clj:983)"
"driver.sql$fn__81669.invokeStatic(sql.clj:40)"
"driver.sql$fn__81669.invoke(sql.clj:38)"
"query_processor.middleware.mbql_to_native$query__GT_native_form.invokeStatic(mbql_to_native.clj:13)"
"query_processor.middleware.mbql_to_native$query__GT_native_form.invoke(mbql_to_native.clj:8)"
"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__51552.invoke(mbql_to_native.clj:20)"
"query_processor$fn__54083$combined_post_process__54088$combined_post_process_STAR___54089.invoke(query_processor.clj:211)"
"query_processor$fn__54083$combined_pre_process__54084$combined_pre_process_STAR___54085.invoke(query_processor.clj:208)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52528$fn__52533.invoke(resolve_database_and_driver.clj:35)"
"driver$do_with_driver.invokeStatic(driver.clj:75)"
"driver$do_with_driver.invoke(driver.clj:71)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__52528.invoke(resolve_database_and_driver.clj:34)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48563.invoke(fetch_source_query.clj:346)"
"query_processor.middleware.store$initialize_store$fn__48751$fn__48752.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:44)"
"query_processor.store$do_with_store.invoke(store.clj:38)"
"query_processor.middleware.store$initialize_store$fn__48751.invoke(store.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__52800.invoke(normalize_query.clj:22)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__49833.invoke(constraints.clj:53)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__52739.invoke(process_userland_query.clj:145)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__53111.invoke(catch_exceptions.clj:167)"
"query_processor.reducible$async_qp$qp_STAR___44972$thunk__44974.invoke(reducible.clj:100)"
"query_processor.reducible$async_qp$qp_STAR___44972$fn__44976.invoke(reducible.clj:105)"],
:card_id 425,
:context :dashboard,
:error "UUID string too large",
:row_count 0,
:running_time 0,
:preprocessed
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:js-int-to-string? true, :ignore-cached-results? false},
:user-parameters
[{:type :string/contains,
:value ["6f139768-65ca-4532-a3ce-f9bf2ddfa481"],
:target [:dimension [:field 3767 {:join-alias "person_poi_user_mapping"}]],
:options {:case-sensitive false},
:id "f8ae319d"}],
:info {:executed-by 1, :context :dashboard, :card-id 425, :card-name "POIs added recently", :dashboard-id 24},
:database 21,
:query
{:source-table 330,
:filter
[:and
[:=
[:field 3663 {:join-alias "person_detail"}]
[:value
true
{:base_type :type/Boolean,
:effective_type :type/Boolean,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "bool",
:name "is_poi"}]]
[:>= [:field 3776 {:temporal-unit :default}] [:relative-datetime 0 :day]]
[:< [:field 3776 {:temporal-unit :default}] [:relative-datetime 1 :day]]
[:contains
[:field 3767 {:join-alias "person_poi_user_mapping"}]
[:value
"6f139768-65ca-4532-a3ce-f9bf2ddfa481"
{:base_type :type/UUID,
:effective_type :type/UUID,
:coercion_strategy nil,
:semantic_type :type/Category,
:database_type "uuid",
:name "user_id"}]
{:case-sensitive false}]],
:aggregation [[:aggregation-options [:distinct [:field 3777 nil]] {:name "count"}]],
:breakout [[:field 3776 {:temporal-unit :day}]],
:order-by [[:asc [:field 3776 {:temporal-unit :day}]]],
:joins
[{:alias "person_detail",
:strategy :left-join,
:fields
[[:field 3658 {:join-alias "person_detail"}]
[:field 3641 {:join-alias "person_detail"}]
[:field 3659 {:join-alias "person_detail"}]
[:field 3638 {:join-alias "person_detail"}]
[:field 3633 {:join-alias "person_detail"}]
[:field 3661 {:join-alias "person_detail"}]
[:field 3637 {:join-alias "person_detail"}]
[:field 3650 {:temporal-unit :default, :join-alias "person_detail"}]
[:field 3653 {:temporal-unit :default, :join-alias "person_detail"}]
[:field 3656 {:join-alias "person_detail"}]
[:field 3664 {:join-alias "person_detail"}]
[:field 3649 {:join-alias "person_detail"}]
[:field 3662 {:join-alias "person_detail"}]
[:field 3647 {:join-alias "person_detail"}]
[:field 3655 {:join-alias "person_detail"}]
[:field 3663 {:join-alias "person_detail"}]
[:field 3632 {:join-alias "person_detail"}]
[:field 3665 {:join-alias "person_detail"}]
[:field 3648 {:join-alias "person_detail"}]
[:field 3657 {:join-alias "person_detail"}]
[:field 3645 {:join-alias "person_detail"}]
[:field 3644 {:join-alias "person_detail"}]
[:field 3652 {:join-alias "person_detail"}]
[:field 3639 {:join-alias "person_detail"}]
[:field 3636 {:join-alias "person_detail"}]
[:field 3646 {:temporal-unit :default, :join-alias "person_detail"}]
[:field 3654 {:temporal-unit :default, :join-alias "person_detail"}]
[:field 3635 {:temporal-unit :default, :join-alias "person_detail"}]
[:field 3643 {:join-alias "person_detail"}]
[:field 3634 {:join-alias "person_detail"}]
[:field 3642 {:join-alias "person_detail"}]
[:field 3651 {:join-alias "person_detail"}]
[:field 3660 {:join-alias "person_detail"}]
[:field 3640 {:join-alias "person_detail"}]],
:source-table 317,
:condition [:= [:field 3777 nil] [:field 3641 {:join-alias "person_detail"}]]}
{:alias "person_poi_user_mapping",
:strategy :left-join,
:fields
[[:field 3771 {:join-alias "person_poi_user_mapping"}]
[:field 3766 {:join-alias "person_poi_user_mapping"}]
[:field 3767 {:join-alias "person_poi_user_mapping"}]
[:field 3768 {:join-alias "person_poi_user_mapping"}]
[:field 3769 {:temporal-unit :default, :join-alias "person_poi_user_mapping"}]
[:field 3770 {:temporal-unit :default, :join-alias "person_poi_user_mapping"}]
[:field 3772 {:temporal-unit :default, :join-alias "person_poi_user_mapping"}]],
:source-table 329,
:condition [:= [:field 3777 nil] [:field 3766 {:join-alias "person_poi_user_mapping"}]]}
{:alias "users",
:strategy :left-join,
:fields
[[:field 3352 {:join-alias "users"}]
[:field 3347 {:join-alias "users"}]
[:field 3355 {:join-alias "users"}]
[:field 3350 {:join-alias "users"}]
[:field 3354 {:join-alias "users"}]
[:field 3349 {:join-alias "users"}]
[:field 3353 {:join-alias "users"}]
[:field 3346 {:join-alias "users"}]
[:field 3345 {:join-alias "users"}]
[:field 3348 {:join-alias "users"}]
[:field 3351 {:temporal-unit :default, :join-alias "users"}]
[:field 3344 {:temporal-unit :default, :join-alias "users"}]],
:source-table 288,
:condition [:= [:field 3767 {:join-alias "person_poi_user_mapping"}] [:field 3352 {:join-alias "users"}]]}]},
:async? true,
:cache-ttl 3},
:data {:rows [], :cols []}}

Not posting full, because it's too large and here words limit.

flamber · October 10, 2022, 1:51pm

@varnika The error being returned by your database is: UUID string too large
It's important to remember the UUID columns are not just regular text columns, they behave differently and you should define them as Entity Key or Foreign Key in Metabase's Data Model.

varnika · October 10, 2022, 2:09pm

yes, I already define user_id as Entity key as shown in picture. But the filter don't allow me to add this user id for the question (POI Universe over week) because it written in native query then converted into

model.

flamber · October 10, 2022, 2:26pm

@varnika You need to create a question based on the Model. And you should be mapping too.
https://github.com/metabase/metabase/issues/23024 - upvote by clicking on the first post
Create a View on your database instead.

varnika · October 10, 2022, 2:39pm

And what about that...

I have added a filter (text and category) in my Dashboard. In this filter I have included user_id which shown in screenshort second. But this filter is not working.

Because for that filter (question converted into model) allow to add but not working.

Any suggestion?

flamber · October 10, 2022, 2:56pm

@varnika I cannot tell you why it's not working, since you're not including any information on why it's not working. Anyways, create a View on your database instead of using Models and SQL questions.

varnika · October 10, 2022, 4:30pm

I tried to create views on metabase directly but some requirements not fullfill by metabase that's why I have to written queries.

I can explain my problem again with explation.

I have want to create filter on my dashboard for user_id. In the dashboard some questions are direct and some from native query. I just want to filter every chart by user_id.
And I added the filter from (text or category) type. It's added but not working.

flamber · October 10, 2022, 4:36pm

@varnika You cannot create views on Metabase. You can only create them directly on your database.

If you cannot create a View, then use SQL with a Field Filter: https://www.metabase.com/docs/latest/questions/native-editor/sql-parameters