Field Filters with with Data Joins

Hi, Currently I'm having a problem applying filters to queries that join tables.

I would like to apply 2 field filters for category and dates, however these 2 fields are in different tables and require a JOIN function.

I am currently getting this error once I run the query.

Unrecognized name: XXX.XXX at [5:70]

Hi @natti
Without seeing your query, then it's difficult to know what's wrong, but you cannot use table aliases with Field Filters.
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type