SQL query for identifying dashboards that utilize rich filter gadgets in an Oracle database.

This 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.

Run the below query in the Oracle database to get the list of dashboards that use the Rich Filter gadgets.

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;

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.

This SQL query is tested on oracle database, please modify the query as per the DB.