How to identify the usage of specific Rich Filter gadgets in Jira Dashboards using the Rich Filters for Jira Dashboards App

Owned by Kinnera, created
Last updated: May 17, 2024 by Amith Mathur
1 min read

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:

    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;

     

    2024-05-15_16-56-44.png

     

  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;
2024-05-15_15-49-19.png

 

  • The SQL queries mentioned are executed in MySQL

  • Make the necessary changes as per the DB used.

Â