How to identify the Rich Filters containing specific JQL in their smart filters

This article provides an SQL query to identify the list of Rich Filters that contain specific JQL in their smart filters for the Jira Dashboard app in the Data Center version.

Instructions

The following SQL query is compatible with PostgreSQL databases:

SELECT
  rf."NAME" AS rich_filter_name,
  rf."ID" AS rich_filter_id,
  sf."NAME" AS smart_filter_name,
  sf."ID" AS smart_filter_id,
  sfc."LABEL" AS clause_label,
  sfc."JQL" AS jql_clause
FROM
  "AO_24D977_QRFRFE0" rf
JOIN
  "AO_24D977_QRFSMFE0" sf
    ON rf."ID" = sf."RICH_FILTER_ID"
JOIN
  "AO_24D977_QRFSMFCE0" sfc
    ON sf."ID" = sfc."SMART_FILTER_ID"
WHERE (sfc."JQL") LIKE '%configuration%';

Query results:

Modify the SQL syntax according to the database.