Dashboard. Edit Filters not showing column information when column table comes from foreign key

[jltest]

Dashboard. Edit Filters not showing column information when column table comes from foreign key

Issue: Dashboard. Edit Filters not showing column information when column table comes from foreign key.

Can anyone reproduce this to confirm the bug?
Thanks a lot

[flamber]

@jltest
Can you also supply the query for the two cards (TEST 1 and TEST 2)

[jltest]

Hi @flamber.
You can see it at https://github.com/metabase/metabase/issues/9267
It is just a simple query with all columns of each table and in Test 2, all colums + columns from “foreign” table.

[flamber]

@jltest
I don’t see the actual query behind those two cards. Please post it. Having to create everything manually from pictures takes a long time instead of you just posting the actual queries.

[flamber]

This might be this issue, which will be fixed in 0.32.0

Issue: Should have unique constraint for Field name + table_id + parent_id and for Table name + schema + db_id

[jltest]

Thanks @flamber

I don’t think it is the same issue, but could be related.
The problem is , after defining the filter for a question in a dashboard and we save it. Then when we open again the dashboiard and edit filters again, we can not see which column was selected

[jshort]

I’m getting the same thing here (v0.31.2), the one card that seems to display correctly is a SQL question, the others are saved with query builder: