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 | 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; | |
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; | |
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; |
Please note that you are required to log out in order to see this feature request.