Summary

The "filter counts" dashboard currently has a db timeout set to 60 seconds. Which means that if the gadgets filter/JQL takes more that 60 seconds to load, the dashboard fails to load with a 504 Gateway Timeout error. In the UI the gadget will just remain blank.

Please increase this timeout period or add the ability to modify this timeout value.

Steps to Reproduce

1. Create a dashboard and add "filter counts" gadget
2. Add a complex JQL with multiple counts (max is 10)
3. Save and then load the dashboard

Expected Result

The gadget loads

Actual Result

Depending on the JQL and Jira DB size, if it take longer then 60 seconds, the gadget won't load; and, we can see a 504 Gateway Timeout in browser console.

results:1 Failed to load resource: the server responded with a status of 504 ()