jltest
January 16, 2019, 7:44am
1
Dashboard. Edit Filters not showing column information when column table comes from foreign key
opened 04:49PM - 15 Jan 19 UTC
closed 05:59AM - 07 Jun 19 UTC
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
@jltest
Can you also supply the query for the two cards (TEST 1
and TEST 2
)
jltest
January 16, 2019, 6:18pm
3
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.
@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.
This might be this issue, which will be fixed in 0.32.0
jltest
January 17, 2019, 7:26am
6
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
7
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: