bug: Filters are not updating with force update if cache is enabled for some time
When the dashboard has a filter and responses are cached for let say 24 hours, even after force refreshing the entire dashboard, list of values in the filter do not update (considering there are new values in filter)
How to reproduce the bug
- Go to dashboard that has dropdown filter
- Force refresh the entire dashboard
- If you expect new value in the filter, it will not be there.
Expected results
Updated filter value should be there.
Actual results
Updated list of values.
Environment
Caching the data for 24 hours. Using superset 3.0.1
@michael-s-molina @kgabryje do either of you happen to know if the cache of the native filters is tied to the linked of the dashboard? Or if there's another way to clear/refresh the cache for the native filters?
@rusackas Using master, I can see that the query to retrieve the filters values is being fired but is not using the force=true parameter and will return cached values.
https://github.com/apache/superset/assets/70410625/e988b1c9-af93-49db-8d2c-51b427399869