How to use filters as use id but show names?

[sayanmaji]

so , what i want is add filter as id but show name so that user can identity better -

for eg there are two tables organizations and members , organizations has id ,and name and members has org.id and member details so my query goes like this

select count(1) from members where {{org_name}}

and in admin →tablemetadata → members i changed the org id to fk and mapped it to organzations id → list all values , everywhere and in display values i changed it to fk and organizations .‘name’

then in query i cahnged the filtere to field filter and mapped it to members.org_id but in filter its showing ‘1-1’, ’2-2’, ’3-3’ not org names

what am i doing wrong ?

[dwhitemv]

Make sure you have organizations.name set as an Entity Name type in Table Metadata.

It sounds like your foreign key is set up wrong, it should link members.org_id and organizations.id. If set up correctly, Metabase will understand the transitive relationship and pull organizations.name when it sees members.org_id.

Finally your query filter should use members.id as a linked field.

[dwhitemv]

Please see the following post, which has a detailed description of how to set up ID fields with name references.

Native SQL Field Filter: How to enable Dropdown List (Foreign Key)?

Cheat sheet for key column filters: Must be less than 1000 unique values–Metabase won’t offer a dropdown (“list of all values”) if there are too many values or they take up too much space (100KB max). You can still use a Search Box if the table doesn’t meet this requirement. Foreign keys must be defined in Table Metadata–Metabase will scan foreign key relationships for most databases, but make sure the FK relationships are correctly expressed. This is not necessary if the ID and name are in th…