Page Comparison

This article provides a SQL query to help Jira administrators identify the usage of "Pie Chart" and "Date Bar Chart" gadgets in Jira Data Center (DC) dashboards.

...

Instructions

1. To find out which dashboards use the gadgets from Rich Filter app and how frequently they are used, run the following SQL query against your Jira DC database:

   Code Block
   language sql
   SELECT pp.pagename as dashboard_name, pc.gadget_xml, count(pc.gadget_xml) FROM portalpage pp JOIN portletconfiguration pc ON pp.id = pc.portalpage WHERE pc.gadget_xml LIKE '%com.qotilabs.jira%' GROUP BY pp.pagename, pc.gadget_xml;

   

2. Copy the name of the gadgets from the gadget_xml to identify the usage of those specific gadgets. In this case, consider the Date Bar chart, Pie Chart as an example:
   

SELECT pp.pagename AS dashboard_name,
       pc.gadget_xml,
       COUNT(pc.gadget_xml) AS gadget_count
FROM portalpage pp 
JOIN portletconfiguration pc ON pp.id = pc.portalpage 
WHERE pc.gadget_xml LIKE '%rich-filter-date-bar-chart-gadget.xml%' 
   OR pc.gadget_xml LIKE '%rich-filter-pie-chart-gadget.xml%'
GROUP BY pp.pagename, pc.gadget_xml;

...