Hello,
I have identified some tables in my databases where the linked filters are not working correctly.
Context:
-
I have three filters: Sport, Competition, and Season, all linked to each other.
-
When I filter by Sport (e.g., Handball), all corresponding seasons appear correctly in the database.
-
On the dashboard, only the competitions related to this sport are displayed (which works as expected).
-
However, in the Competition filter, no values appear.
-
Similarly, if I filter by Competition, the selection works, but the other filters remain empty.
I would like the linked filters to display all corresponding values correctly in both directions.
The tables where this issue occurs are: Competition_season_translations and Positions.
Usually this is due to a missing foreign key relationship.
Can you describe your database schema? Is the Competition data source in the same table as the other two filters, or a different table?
Review the documentation for Linked Filters here and verify the table relationships are properly described in Metabase:
I've checked, and all the foreign key relationships are correct.
Furthermore, if the foreign keys were causing problems, there would be an issue with the dashboard. Here, it's only detected through filters.
I have four tables that link competition names to sports (and similarly sports to seasons):
Competition_season_translation (id, competitionSeasonID, name) → Competition_seasons (id, competitionID) → Competitions (id, sportsID) → Sports (id, name).
There is an issue with the table linking seasons to sports.
Season_translation (season_ID, name) → Competition_season (season_ID, competitionID) → Competition (id, sportsID) → Sports (id, name).
