How to disable issue filter subscriptions for all users

[Tayyab Bashir]

Hi, 

I have a Test instance of JIRA on which I am doing some testing and need emails to be enabled.

But there are many filter subscriptions on it from many users (as its the XML backup of production server).
Is there a way to disable JUST the issue filter subscriptions and keep everything else intact? 

Thanks 

[Koen Gillard]

Take a look at subscriptions-for-jira-filter-manager

[francis]

Nice one @Koen Gillard 

[Vasiliy Zverev]

You can diable out mail at all: admin panel => system => mail => out mail => press button disable

[Tayyab Bashir]

Hi, 
I don't want to disable all the emails, I want to disable just the filter subscriptions. 

[Vasiliy Zverev]

Then you can try execute this code to delete all subsriptions (for example, via Script Runner)

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.subscription.FilterSubscription
import com.atlassian.jira.issue.subscription.SubscriptionManager

SubscriptionManager subscriptionManager = ComponentAccessor.getSubscriptionManager();
for(FilterSubscription subscription: subscriptionManager.getAllFilterSubscriptions()){
    subscriptionManager.deleteSubscription(subscription.getId())
}

DO NOT EXECUTE IT ON PROD INSTANCE

[Tayyab Bashir]

This didn't do anything? 

[Vasiliy Zverev]

It should to delete all subsriptions.

[Tayyab Bashir]

It does run but it doesn't delete the filters. I tried re-indexing as well. 

Capture.PNG

FYI: JIRA Version: 7.0.5

[Vasiliy Zverev]

This script does not delete filters, only subsription. 

You can get all subscriptions with this one:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.subscription.FilterSubscription
import com.atlassian.jira.issue.subscription.SubscriptionManager

StringBuilder result = new StringBuilder();
SubscriptionManager subscriptionManager = ComponentAccessor.getSubscriptionManager();
for(FilterSubscription subscription: subscriptionManager.getAllFilterSubscriptions()){
    result.append("{ " + subscription.getLastRunTime().toString() + " / " + subscription.getFilterId() + " }")
}

return result.toString()

[Tayyab Bashir]

JIRA Version: 6.0

Gave error when I tried to run the script.

[Tayyab Bashir]

Capture.PNG

JIRA Version: 6.0

Gave error when I tried to run the script.

[Vasiliy Zverev]

Hm, this code will work only 6.2+.

Since try this SQL to get all subscriptions:

Select
    filtersubscription.*
    , searchrequest.*
from
    filtersubscription
    left join   searchrequest   on  filtersubscription.FILTER_I_D = searchrequest.ID