This knowledge base article explains how to run an SQL query in Oracle Database to identify dashboards that use Rich Filter gadgets in a Jira Server/Data Center instance.
This SQL query provides a distinct Run the below query in the Oracle database to get the list of dashboards that incorporate use the Rich Filter gadgets. It details each dashboard's ID, name, the username of its owner, and the specific Rich Filter gadget ID and name used.
Code Block |
---|
SELECT DISTINCT d.id AS dashboard_id, d.pagename AS dashboard_name, d.username AS dashboard_owner_username, rf.ID AS rf_id, rf.NAME AS rf_name FROM portalpage d, portletconfiguration g, gadgetuserpreference p, AO_24D977_QRFRFE0 rf WHERE d.id = g.portalpage AND g.id = p.portletconfiguration AND p.userprefkey = 'rf' AND TO_CHAR(SUBSTR(p.userprefvalue, 1, 100)) = TO_CHAR(rf.ID) ORDER BY dashboard_id; |
In the above command:
...
dashboard_id: The unique identifier for each dashboard.
...
dashboard_name: The name of the dashboard as configured in Jira.
...
dashboard_owner_username: The Jira username of the person who owns the dashboard.
...
rf_id: The unique identifier of the Rich Filter gadget used in the dashboard.
...
The SQL query above will return the list of dashboards that use at least one rich filter gadget. For each dashboard, the query returns these values:
Dashboard ID
Dashboard name
Dashboard owner
Rich filter ID
Name of the rich filter used in that dashboard.
The same rich filter can be used in multiple dashboards and each dashboard can use multiple rich filters, there is an n-to-n relationship between dashboards and rich filters.
Info |
---|
This SQL query is tested on oracle database, please modify the query as per the DB. |