Cannot link text/field filters on dashboard

[Alex_DA]

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.

[Alex_DA]

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.

[TonyC]

Can you share the SQL of those questions

[Alex_DA]

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`

[Clara]

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

[TonyC]

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

Uncaught "Unknown type of ref" when trying to link a new Dashboard Filter to a SQL-Question

Should be fixed with 50.10 can you upgrade and check please

[Gabrielle]

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 !

[Alex_DA]

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

[alit]

Hello Alex,

When you say you cannot select it again. You still have the column in the list of filters available but you cannot select it right ?
Or is it something different ?

[Alex_DA]

Hello alit,
Yes indeed, columns were available but I couldn't select them.
But it was all fixed.