Field Filters as a drop-down list

hi all, I need to use Field Filters as a drop-down list, I add the setting in the picture in 3# and do the select
:SELECT *
FROM data.pilot
WHERE from_date <= ‘2019-09-21 17:15:00’
AND ‘2019-09-22 00:00:00’ <= to_date
[[AND station_name = {{pilot}}]]
or this
SELECT *
FROM data.pilot
WHERE from_date <= ‘2019-09-21 17:15:00’
AND ‘2019-09-22 00:00:00’ <= to_date
[[AND {{pilot}}]]

like in 1# but I get an error like 2#
why? I use version v0.36.6

Hi @reli
Because you’re using Field Filters incorrectly - the syntax is without column reference, and you need to include the table in from/join-clause (without aliases).
Have a look here:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html

Thanks for the quick reply!