Retrospectively share all user dashboards

Question

Hi, reasonably new to JIRA here.

We've recently changed our User Preference configuration to set dashboard and filter sharing to public by default.

However, there are obviously still a number of user-defined filters and dashboard that are not set to shared. We'd like to convert these to shared and have our users now explicitly unshare their filters/dashboards.

Is there a way to do this easily within JIRA or through SQL?

Thanks.

Renjith Pillai · Answer

Even though this does not completely help you, this plugin may ease your job

https://plugins.atlassian.com/5043

Adam Jacobson · Answer

It seems the best I can do so far with SQL is query for all the existing shared dashboards:

select entityid,sharetype,param1 from sharepermissions where entitytype='PortalPage';

Adam Jacobson · Answer

Thanks Mirek. I would actually prefer to retain the original ownership and simply set all the dashboards to shared for Everyone.

I have access to the administration, and we are using JIRA 5.0.1