SQL Query to Identify Dashboards Using Rich Filter Gadgets in Oracle Database

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 list of dashboards that incorporate 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.

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.

• rf_name: The name of the Rich Filter gadget.