Optional filter not work

Optional filter does not work, mapped field (mongodb)
Also happens in other database engines

not results found!

without adding filter, it’s work
image

the filter only works on “text variable type”, but the drop-down list is lost, since in this option the field is not mapped

Hi @jlcornejo
Please read this article - the syntax for Field Filters are different than other filter type - you should not include the column:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html

1 Like

I was applying the filter type wrong, now it works, thanks.