I created a dashboard on superset with the objective to have close to real time data displayed. I configured the auto-refresh time, which worked perfectly; however, this auto-fresh does not applied to filters. The main issue is that the date filter does not get update when I start getting data from the new day and demand intervention from the user to manually refresh it.

How to reproduce the bug

  1. Set aut-refresh time on a dashboard
  2. Create a day filter (in my case, created year, month and day)
  3. Wait for the next day to come and add new information to your database
  4. See that the day filter is not updated

Expected results

Filters being reloaded automatically when database base is updated with information from the enxt day.

Actual results

Filter keeps current values and demand user to reopen the dashboard.

Environment

(please complete the following information):

  • Version 114.0.5735.199 (Official Build) (64-bit)
  • superset version: 2.0.1

Checklist

Make sure to follow these steps before submitting your issue - thank you!

  • [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
  • [ ] I have reproduced the issue with at least the latest released version of superset.
  • [ ] I have checked the issue tracker for the same issue and I haven't found one similar.

Additional context

Changed FILTER_STATE_CACHE_CONFIG, but did help with the issue.

Comment From: rusackas

Is this still an issue in 3.x or newer?

Comment From: cmartinezdnn

Is this still an issue in 3.x or newer?

Yes. I confirm I am experiencing this behaviour in 4.0.2.

Comment From: rusackas

I'm assuming this is still valid in 4.1.2/5.0.0, but this thread has gone silent for quite a while. I suspect it's just an edge case that isn't rising to the top of any Committer's TODO list. Any volunteers here on the thread willing to dig into it?

Comment From: rusackas

This sounds like a somewhat unusual yet important issue, so we'd love to have this validated in 5.0 now that it's out. If we don't hear back soon, we'll close it as inactive/not-planned. Still open to investigations/contributions here.