Migration of JIRA Server/ Data Center Dashboard Gadgets to Cloud
Background
Currently, it is not possible to migrate third-party gadgets in dashboards from Server to Cloud. (Refer to MIG-1937 )
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;
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;
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;
.png){kind=logo}