Every Jira Administrator knows this feeling:
User: Hello my dear Jira Admin! Can you rename this custom field?
Jira Administrator: Hi! Is the change really necessary?
User: Yes. It’s just a name. What could possibly go wrong 
?
Jira Administrator: Well… every saved filter using that name in its JQL could be affected.
User: That’s fine. Atlassian must have an easy and native way to find all those filters.
Jira Administrator: Absolutely! Let me just click on the… Mmm… Oh, wait! 😱
This conversation may sound familiar to many Jira Administrators.
Before renaming a custom field, changing a project, or removing a value, you may need to know which saved filters could be affected.
Finding this information manually can take a lot of time, especially in a large Jira Cloud site.
That is why I created Jira Filter Explorer, a simple chart for Atlassian Analytics.
Isn’t it great? Now you can easily find the saved filters that may be affected by a Jira configuration change!
For every filter, it displays:
- The filter name
- A direct link to open the filter in Jira
- The saved JQL
- The name of the person who created the filter
- For privacy reasons, I've hidden the column that shows the filter. When you recreate this chart in your own instance, you'll see an extra column with the filter. Just click on it and the filter will open in a new browser tab. Very handy!
The table also includes a native search box.
You can search for:
- A custom field name
- A custom field ID
- A project key
- A status
- A component
- A label
- A JQL function
- A filter creator
- Any other text included in the saved JQL
For example, before renaming a custom field, enter its current name in the table search. The chart will show the saved filters that may need to be reviewed.
Follow these steps to create the Jira Filter Explorer
Enter Atlassian Analytics: https://YOURSITE.atlassian.net/analytics/
Click on the Create Dashboard blue button on the top-right corner:
Create a new chart on the dashboard:
Select the custom chart option:
Select the SQL tab option:
Copy and paste the SQL code below, then click “Run Query”:
SQL query:
SELECT DISTINCT
`Filters`.`name` AS `Filter Name`,
CASE
WHEN `Filters`.`url` LIKE 'https://%'
OR `Filters`.`url` LIKE 'http://%'
THEN `Filters`.`url`
ELSE 'https://' || `Filters`.`url`
END AS `Filter URL`,
`Filters`.`saved_jql` AS `JQL`,
COALESCE(
`Creator`.`name`,
`Filters`.`created_by`
) AS `Created By`
FROM `jira_filter` AS `Filters`
LEFT JOIN `account` AS `Creator`
ON `Filters`.`created_by` = `Creator`.`account_id`
WHERE
`Filters`.`name` IS NOT NULL
AND `Filters`.`url` IS NOT NULL
AND TRIM(`Filters`.`url`) <> ''
ORDER BY
`Filter Name` ASC;
The chart has been created successfully:
Note: For privacy, I've hidden the filter column. In your instance, you'll see it, and clicking a filter opens it in a new tab. Super handy!
Now, enter a custom field name to find all the saved filters that contain an exact match in their JQL:
Less searching, faster JQL analysis, and fewer surprises when changing Jira configuration 😄
Have you built any Jira Admin life-saving charts in Atlassian Analytics?
#Jira #Atlassian #AtlassianAnalytics #JiraAdministrator #WorkflowManagement
