I noticed the SQL editor template variables only have four type: text,number,date and fieild filter
I want to use array type to search,and I try it like this:
and it is not work, seem like it can not recognized as an array
so how can I use array variable in SQL template variables? thanks:sob:
Hi @jiaxing
You would have to do casting in your query. When you select Text, then Metabase sends a string.
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html
yes！the filter type can choose multiple value like a array. but how can I let url params to replace filter type value?
http://10.50.125.141:30033/public/dashboard/040f35e0-b3e7-4bd6-a008-833abb479175?lastStartTime=[value1,value2,value2]http://10.50.125.141:30033/public/dashboard/040f35e0-b3e7-4bd6-a008-833abb479175?lastStartTime=value1,value2,value2@jiaxing You are using Field Filters, which works differently than the other filter types. See the documentation.
https://www.metabase.com/learn/sql-questions/field-filters
Thanks for your patience！ but there a anthor question 
then I use URL params at add new question page, it`s work. but at dashboard page, it is not work.
please forget about the chinese words 
and sorry about my english.
first I create organizations variable on url, and set it 430112, you can see the table
then I change the variable, set it 430100, and you can see the table changed!
then I add the question to a dashboard, like this
because the organizations variable default value is 430112, the table is same like first img
then I add url params like this
http://10.50.125.141:30033/dashboard/1?organizations=430100
it should become like the second img, but it not change,
so I check the network log, the page have url params
but the card query do not have url params
thank you!!!
@jiaxing There's no filter on the dashboard:
https://www.metabase.com/docs/latest/users-guide/08-dashboard-filters.html