disable query caching

[Czech Jiri]

Is there any option to disable caching for selected queries? In another words refresh them every time user opens a page?

I have a dashboard with few queries setup with a parameter, I dont need to (and cannot) refresh these every X minutes. Ideally I would like specific queries to re-run when they are opened on a dashboard (fully understand there will be latency since the queries are not cached because the content is changing).

[Arik Fraimovich]

Do you need all the queries on this dashboard to refresh or only some of them? 

On Wed, Jan 13, 2016 at 10:16 PM Czech Jiri <czec...@gmail.com> wrote:

Is there any option to disable caching for selected queries? In another words refresh them every time user opens a page?

I have a dashboard with few queries setup with a parameter, I dont need to (and cannot) refresh these every X minutes. Ideally I would like specific queries to re-run when they are opened on a dashboard (fully understand there will be latency since the queries are not cached because the content is changing).

--
You received this message because you are subscribed to the Google Groups "re:dash users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redash-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Czech Jiri]

ideally all of them, that tiny little icon "enable/disable auto refresh" really does not do anything at all, honestly I dont even mind to do this globally across all queries/dashboards

thank you

[Arik Fraimovich]

The "Enable/Disable Auto Refresh" is used to refresh queries that have scheduled updates. It doesn't run them again.

If you append "maxAge=0" to the dashboard URL it will refresh all queries, for example:

http://demo.redash.io/dashboard/refresh-example?maxAge=0

You should see the current time in the widget there, every time you open the dashboard.

Will this solution work for you?

[Czech Jiri]

Yes, this is exactly what I need!

thanks a lot