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

Multiple Filters Chart Gadget for Jira

CODE

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

CODE

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

CODE

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.