Jira Query to list out the Users who have turned on refresh for every 15mins option on their Gadget.

[Deleted user]

Hello All !

Few Jira Users are enabling the "refresh for every 15 mins" option in gadget which are leading to jira performance issues. Is there any way to find out which users are enabling the option.

Thanks in advance !

[Ollie Guan]

Hello @[deleted] ,

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.

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:

UPDATE gadgetuserpreference SET userprefvalue='false' WHERE userprefkey='refresh';

How to update auto refresh interval in gadgets globally

[Deleted user]

Hello @Ollie Guan ,

Thanks for the fast response ! Your answer is very helpful to me. But I need a solution without changing or disturbing the database. Is there any solution like filter queries to get the users list who enabled the refresh option in gadget or is there a way to set the permissions for enabling the refresh option only to admins.

Thanks in advance !