Optional filter does not work, mapped field (mongodb)
Also happens in other database engines
not results found!
without adding filter, it's work
Optional filter does not work, mapped field (mongodb)
Also happens in other database engines
not results found!
without adding filter, it's work
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
I was applying the filter type wrong, now it works, thanks.