Document toolboxDocument toolbox

Migration of JIRA Server/ Data Center Dashboard Gadgets to Cloud

Background

Currently, it is not possible to migrate dashboards from Server to Cloud. (Refer to MIG-164)

Workaround

The only method for migrating gadgets would be to add them manually.

You can use the following SQL query to identify dashboards using the gadget and the filters tied to the gadget.

Plugin

SQL Query

Feature Request

Plugin

SQL Query

Feature Request

Multiple Filters Chart Gadget for Jira

SELECT pp.id as "Dashboard ID", pp.pagename as Dashboard, u.lower_user_name as "Dashboard Owner", pc.GADGET_XML as Gadget, gp.USERPREFvalue as Filters FROM portletconfiguration pc JOIN portalpage pp on pp.ID = pc.portalpage JOIN gadgetuserpreference gp on gp.PORTLETCONFIGURATION = pc.id JOIN app_user u on u.user_key = pp.USERNAME WHERE pc.GADGET_XML like '%MultipleChartsGadget%' and gp.USERPREFvalue LIKE '%filter%' ORDER BY pp.id;

MCHART-62

Gauge Gadgets Plugin for Jira

select pp.id as "Dashboard ID", pp.pagename as Dashboard, u.lower_user_name as "Dashboard Owner", pc.GADGET_XML as Gadget, gp.USERPREFvalue as Filters from portletconfiguration pc join portalpage pp on pp.ID = pc.portalpage join gadgetuserpreference gp on gp.PORTLETCONFIGURATION = pc.id join app_user u on u.user_key = pp.USERNAME where pc.GADGET_XML like '%GaugeGadget%' and gp.USERPREFvalue LIKE '%filter%' order by pp.id;

GAUGE-48

3D Date Gadgets

select pp.id as "Dashboard ID", pp.pagename as Dashboard, u.lower_user_name as "Dashboard Owner", pc.GADGET_XML as Gadget, gp.USERPREFvalue as Filters from portletconfiguration pc join portalpage pp on pp.ID = pc.portalpage join gadgetuserpreference gp on gp.PORTLETCONFIGURATION = pc.id join app_user u on u.user_key = pp.USERNAME where pc.GADGET_XML like '%ThreeDDateGadgets%' and gp.USERPREFvalue LIKE '%filter%' order by pp.id;

TDDG-52

Please note that you are required to log out in order to see this feature request.