superset icon indicating copy to clipboard operation
superset copied to clipboard

bug: Filters are not updating with force update if cache is enabled for some time

Open pankajsoni22 opened this issue 2 years ago • 2 comments

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

  1. Go to dashboard that has dropdown filter
  2. Force refresh the entire dashboard
  3. 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

pankajsoni22 avatar Nov 07 '23 16:11 pankajsoni22

@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 avatar Apr 05 '24 17:04 rusackas

@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

michael-s-molina avatar Apr 05 '24 17:04 michael-s-molina