Need help with The Field Filter

Sql like this,
select id, name, category_id from table1 where {{cat1}}

category table like this,
select id, name from category

How does metabase know i want to get a condition on table1.category_id column?
like this “where table1.category_id in ()”.

Hi @cengjing2000
Because you have referenced the table.column in the sidebar. I would recommend that you read this:
https://www.metabase.com/blog/field-filters/index.html