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

jltest · January 16, 2019, 7:44am

github.com/metabase/metabase

Dashboard. Bug Visualization 0.31.2. Edit Filters not showing column information when column table comes from foreign key, and not saving default values for filters.

opened 04:49PM - 15 Jan 19 UTC

closed 05:59AM - 07 Jun 19 UTC

jlisyc

Type:Bug Priority:P2 Reporting/Dashboards Querying/Parameters & Variables

### Bug. Dashboard. Edit Filters not showing column information when column tabl…e comes from foreign key, and not saving default values for filters ### - Your browser and the version: (Firefox 60.0.1,) - Your operating system: (ubuntu 16.04) - Your databases: (Postgres) - Metabase version: (0.31.2) (in 0.30.4 works ok) - Metabase hosting environment: (Linux/Ubuntu) - Metabase internal database: (Postgres) ## Steps to reproduce 1. Database. Table "test_a" as: ![image](https://user-images.githubusercontent.com/33416503/51193315-dfef6c00-18e8-11e9-922d-05cb9ca2ca01.png) Table "test_b" as (with foreign key to test_a): ![image](https://user-images.githubusercontent.com/33416503/51195332-21821600-18ed-11e9-908b-4d388c94b7f2.png) 2. Create dashboard based in both question (A TEST 1 from table test_a , and A TEST 2 from table test_b). ![image](https://user-images.githubusercontent.com/33416503/51195388-3f4f7b00-18ed-11e9-8281-2af88473d9f9.png) 3. Add filter definition ![image](https://user-images.githubusercontent.com/33416503/51195019-8a1cc300-18ec-11e9-80d3-bcc48dbb1250.png) 4. Bug. IN 0.31.2 , If we open again , we can not see filters definitions in the second question (the one we apply filter of foreign key) , And also , it is not saving default values for filters. It still works, but it is not possible to visualize ![image](https://user-images.githubusercontent.com/33416503/51195594-b08f2e00-18ed-11e9-8afd-c51cf8b762c6.png) ------------------- ------------------- Still persist the problem in 0.32.4 ![image](https://user-images.githubusercontent.com/33416503/56113813-4a06c400-5f5f-11e9-95fb-2d3881121fd9.png) ------------------- Thanks for Metabase project! -------

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

flamber · January 16, 2019, 6:04pm

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

jltest · January 16, 2019, 6:18pm

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 · January 16, 2019, 6:34pm

@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 · January 16, 2019, 7:36pm

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

jltest · January 17, 2019, 7:26am

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 · January 17, 2019, 3:44pm

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: