Filter with two variables

khawla · February 22, 2020, 9:45am

Hello can I add two variables filter in my question sql because I add two variables but the second it’s not work by me can you give me a solution please ?

flamber · February 22, 2020, 10:57am

Hi @khawla
Yes, you can have multiple filters. Have a look at the documentation:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html
If you’re still having problems, then post your query and “Diagnostic Info” from Admin > Troubleshooting.

khawla · February 22, 2020, 10:43pm

Hi @flamber It’s work by me with two variables but can I add more than two variables filter ? and thank you so much for your reply

flamber · February 23, 2020, 12:28pm

@khawla Yes, you can use multiple filters. Post your query.

khawla · February 23, 2020, 3:05pm

@thank you for your attention, so I add a 3 variables like that and I pute the field on the variable (x) but I find just two variables at the top are for the name and cerated at but I also want to add the email filter, what is my problem exactly?

flamber · February 23, 2020, 3:10pm

@khawla I cannot see the “Filter widget type” of the Email variable. Make sure that the “Field Type” for People.Email is set to one of the types that can be displayed as Field Filter:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type

khawla · February 23, 2020, 4:05pm

@flamber thank you so much