Using a text variable in my filter I get the expected count:
...but using a field filter variable filter I do not:
Underlying database is sqlite. Metabase version is v0.33.4.
Using a text variable in my filter I get the expected count:
...but using a field filter variable filter I do not:
Underlying database is sqlite. Metabase version is v0.33.4.
Hi @smccandl
When using Field Filter, you should not include the column in the query, since that is inserted automatically:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type
Thanks @flamber. I missed that it works a bit differently than the text filter. It’s working as you described. Appreciate the help!