How to set a list of values for display filters

Get Help
1

image
For example,
I want to display only 'B' in the filter, how should I modify the sql query?
select type,title from demo where {{type}}

2

Hi @beta
If I understand your question correctly, then you cannot limit the Field Filter options based on a filter. You can use a different table as your Field Filter, which only contains the options you want.
There’s a request open - go and upvote by clicking :+1: on the first post:
https://github.com/metabase/metabase/issues/5540

3

ok，I understand，thank you.