[0.42] Dashboard with default filter value emptied fails (fixed)

Hi !

I encounter a strange behaviour since v0.42.

I have a SQL-question like :

SELECT ALL id, name, country
FROM providers
WHERE TRUE
    [[AND {{ provider }}]]

provider filter is bind to providers.name column.

I have a dashboard with a filter "Provider" binded to the question's provider filter. This dashboard filter's default value is "Microsoft".

When I access to the dashboard, I am redirected to :

/dashboard/123-providers-dashboard?provider=Microsoft

All is good at this stage.

When I clear the filter with the dashboard filter widget cross icon the URL becomes :

/dashboard/123-providers-dashboard?provider=

And the question fails ("There was a problem displaying this chart.") instead of displays result with all providers.

If I remove dashboard's provider filter default value "Microsoft" all is good with URL like :

/dashboard/123-providers-dashboard
/dashboard/123-providers-dashboard?provider=Microsoft
/dashboard/123-providers-dashboard?provider=Apple

Any idea ?

Cheers,

@sfa I've created an issue for this:
https://github.com/metabase/metabase/issues/20493 - upvote by clicking :+1: on the first post

1 Like

Fixed with 0.42.1

Thx