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