Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.