How to find all filters that I have a subscription for

[O]

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

How can I find this filter?

[somethingblue]

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.

1. Enter your search criteria in the search box above the list of filters.
2. 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

[MohanaPriya B]

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

[Deleted user]

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 = '<filtername>');

-- show all filter subscriptions of a single user
SELECT fsub.*, sreq.filtername
FROM filtersubscription fsub, searchrequest sreq
WHERE fsub.username = '<username>'
AND fsub.filter_i_d = sreq.id
ORDER BY sreq.filtername;