Custom MongoDB Query for Dropdown Filter

We want to populate a dropdown filter in Metabase using a MongoDB collection named "A", but only include records where status is "active".

Right now, the dropdown shows all records, regardless of status.

Does anyone know how to use a custom MongoDB query to filter the dropdown values?

Right now, the dropdown shows all records, regardless of status.

Does anyone know how to use a custom MongoDB query to filter the dropdown values?