Field Filter contains values absent in final resultset

Get Help
1

Hi Team,

The dropdown of field filter is expected to have values that are present in final result. But the dropdown contains all values in tables (including the one absent in final result)

Is this a bug? How can I limit the values in field filter to values that are present in final result?

To replicate:

SELECT *
FROM products
WHERE True
  AND id = 2
  [[AND {{category}}]]

image
image1541×563 29 KB

Here the expected values in category Field Fielter is Doohickey, but all are listed

2

Hi @mohannv
That is available via Sandboxing in the Enterprise Edition: https://www.metabase.com/docs/latest/enterprise-guide/data-sandboxes.html
And another option is Linked Filters on dashboards since 0.37:
https://www.metabase.com/blog/linked-filters/index.html