Field Filter does not working properly

Hi everyone

I'm trying to setup a dashboard with some FieldFilter in order to let the user filter the value.
Here it is my query:

SELECT  * 
FROM "dm_demo_insurance"."crashs_summary"
where 1=1
[[and crashtimestamp = {{crashtimestamp}} ]]
[[and speed = {{speed}} ]]
[[and intensity = {{intensity}} ]]
[[and crashtype = {{crashtype}} ]]

the main problem is this:

Once i click on a field filter and select an option, the widget stop working completely and i get this message:

[Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. line 9:100: mismatched input ')'. Expecting: <expression> [Execution ID not available]

Seems query not matching correctly the field filter or sort of.
Currently im running metabase on docker.

Hi @aresb
You don't include the column or operator, when using Field Filters.
Read this: https://www.metabase.com/learn/sql-questions/field-filters
And if you are still having problems, then please read it one more time.

1 Like

Thank you!!!