Cannot link text/field filters on dashboard

Hello there,
I have a trouble that I didn't have until now on a dashboard filter. Once I removed the selection of a field filter on my dashboard, I cannot select it again . I did not make any change on this filter (wether on the SQL query filter parameters or in the dashboard filter parameters). I do not have problems with the other types of filters (date, numerics) and when I run this filter on the SQL query alone, there is no problem.

1 Like

Note : this seems to be exclusively on my SQL queries. In this dashboard I also have metabase questions that seems to work pretty well with the filter.

Can you share the SQL of those questions

Yes of course. Here is the query and the 'hospital' variable settings in screenshot (named 'Etablissement' after).
Note : the tables named "metabase_list_x" were created specifically for metabase purpose ; as I need to use filed filter but that informations can be intertwined, we went for this solution.

SELECT
	COUNT(DISTINCT r.id) AS count,
	YEAR(r.primary_opinion_date)  AS 'Year',
	DATE_FORMAT(r.primary_opinion_date, '%m - %M') AS 'Month'
FROM
	request AS r
	LEFT JOIN partner AS p ON IFNULL(r.partner_id, r.landing_page) = p.id
	LEFT JOIN reference AS rasp ON r.how_did_you_know_association_id = rasp.id
	LEFT JOIN metabase_list_year ON YEAR(r.primary_opinion_date) = metabase_list_year.name
	LEFT JOIN metabase_list_month ON DATE_FORMAT(r.primary_opinion_date, '%m - %M') = metabase_list_month.name
	LEFT JOIN metabase_list_payer ON IFNULL(p.global_name, p.name) = metabase_list_payer.name
	LEFT JOIN metabase_list_partner ON (r.partner_id = 14 AND r.source_category = metabase_list_partner.name) OR p.name = metabase_list_partner.name
	LEFT JOIN metabase_list_acquisition_source ON rasp.name = metabase_list_acquisition_source.name
	LEFT JOIN expert_location AS exl ON r.expert_id = exl.expert_id AND exl.active = 1 AND exl.main = 1
	LEFT JOIN hospital AS h ON exl.hospital_id = h.id
	LEFT JOIN metabase_list_hospital ON h.name = metabase_list_hospital.name
	LEFT JOIN expert AS e ON r.expert_id = e.id 
WHERE
	1
	[[AND {{year}}]]
	[[AND {{month}}]]
	[[AND {{payer}}]]
	[[AND {{partner}}]]
	[[AND {{acquisition_source}}]]
	[[AND {{hospital}}]]

GROUP BY
	`Year`,
	`Month`

I have the same problem, even in the latest version v0.50.9
But on my side, it can be not only for text filters but also for dates

1 Like

Ans same for SQL questions? I think you might be hitting this problem:

Should be fixed with 50.10 can you upgrade and check please

1 Like

I was experiencing the same issue (I couldn't link dashboard filters to new SQL questions) : I just upgraded Metabase to v0.50.10, and I confirm that the problem is now solved ! :clap:

3 Likes

We just upgraded Metabase to v0.50.10, and I confirm that this issue is fixed on my side ! :tada:
Thanks a lot for the answers.