Not able to use a field filter with SQL query

Hi, I am a newbie to Metabase. I am trying to use a simple SQL query with 2 tables (left outer join) and trying to use a field filter in the where clause. I mapped the field filter with the database table and column. When I try to run the query it throws error saying "Unknown column in the where" complaining about the column used in the field filter. If I just use only one table without any joins then it seems working. Anyone faced anything like this and does this have a working solution?

Here is an example query that I am trying to run:
select *
left outer join REVIEWS r on r.product_id =
where {{product_filter}}

Hi @raj006
Field Filters does not work with table aliases:

Got it. Thank you so much @flamber.