How to find all filters that I have a subscription for

Question

I've subscribed to a filter which is neither my own filter nor in my favorites list.

How can I find this filter?

unknown · Answer

There's a workaroud if you have database access, these 2 SQL queries worked for me on Jira 6.0: -- show all users who are subscribed to a single filter SELECT * FROM filtersubscription WHERE filter_i_d = (SELECT id FROM searchrequest WHERE filtername = ''); -- show all filter subscriptions of a single user SELECT fsub.*, sreq.filtername FROM filtersubscription fsub, searchrequest sreq WHERE fsub.username = '' AND fsub.filter_i_d = sreq.id ORDER BY sreq.filtername;

MohanaPriya B · Answer

Is there any there way to find the subscriptions for the filter other than installing the Add on

somethingblue · Answer

Hi,

If the filter is shared you can find it like this:

Searching for a filter

You can find and run any filters that you have created or that have been shared by other users.

* Enter your search criteria in the search box above the list of filters.
* Select the name of any issue filter to run it.

In addition, there is an add-on that can help you see all your subscriptions called Subscriptions for Jira - Filter Manager that may help as well.

Cheers,

Branden