How to update auto refresh interval in gadgets globally
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Some of the gadgets type can be configured with an auto refresh interval set to 15 minutes that cannot be configured within a user interface. However, this may cause unnecessary strain to the system if there are many gadgets operating in the same time.
Solution
It is possible to automatically disable refresh in all existing gadgets or set them to a different interval. The gadgets settings are stored in the gadgetuserpreference table, which can be manipulated with help of the following sample queries:
Disabling refresh in all existing gadgets
1
UPDATE gadgetuserpreference SET userprefvalue='false' WHERE userprefkey='refresh';You can set the auto refresh to a predetermined interval in minutes:
Setting all existing gadgets auto refresh interval to 4 hours
1
UPDATE gadgetuserpreference SET userprefvalue='240' WHERE userprefkey='refresh';Restart JIRA for the setting to take effect. Note that any active dashboards will need to be reloaded for new setting to take effect.
Was this helpful?