How to List Subscribed Filters by a Specific Group in Jira
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
The information in this page relates to customizations in Jira. Consequently, Atlassian Support cannot guarantee to provide any support for the steps described on this page as customizations are not covered under Atlassian Support Offerings. Please be aware that this material is provided for your information only and that you use it at your own risk.
When managing groups in Jira, Jira admin may encounter a situation where admin needs to delete a group. However, Jira will sometimes display a warning message stating: "This group is referenced in the following filter subscriptions: These filter subscriptions will be automatically deleted." If the Jira admin wants to identify which filters the group is subscribed to, this information is not readily available in the Jira UI.
Solution
To retrieve the list of filter subscriptions for a specific group, Jira admin can use a below mentioned SQL query directly on the database -
Postgres DB
1
2
3
4
5
6
7
SELECT "filtername_lower"
FROM searchrequest
WHERE id IN (
SELECT "filter_i_d"
FROM filtersubscription
WHERE groupname = '<Group_name>'
);Oracle DB
1
2
3
4
5
6
7
SELECT filtername_lower
FROM searchrequest
WHERE id IN (
SELECT filter_i_d
FROM filtersubscription
WHERE groupname = '<Group_name>'
);MSSQL
1
2
3
4
5
6
7
SELECT filtername_lower
FROM dbo.searchrequest
WHERE id IN (
SELECT filter_i_d
FROM dbo.filtersubscription
WHERE groupname = '<Group_name>'
);Here, dbo is used as schema name. If schema name is different, accordingly the query should be updated.
MySQL DB
1
2
3
4
5
6
7
SELECT filtername_lower
FROM searchrequest
WHERE id IN (
SELECT filter_i_d
FROM filtersubscription
WHERE groupname = '<Group_name>'
);Replace <Group_name>: Substitute <Group_name> with the actual name of the group for which filter subscriptions needs to be retrieved.
Was this helpful?