How to disable issue filter subscriptions for all users

Tayyab Bashir Community Champion Feb 02, 2016

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 

2 answers

1 vote
Vasiliy Zverev Community Champion Feb 02, 2016

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

Tayyab Bashir Community Champion Feb 02, 2016

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

Vasiliy Zverev Community Champion Feb 02, 2016

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 Community Champion Feb 03, 2016

This didn't do anything? 

Vasiliy Zverev Community Champion Feb 03, 2016

It should to delete all subsriptions.

Tayyab Bashir Community Champion Feb 03, 2016

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 Community Champion Feb 04, 2016

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 Community Champion Feb 04, 2016

JIRA Version: 6.0

Gave error when I tried to run the script.

Tayyab Bashir Community Champion Feb 04, 2016

Capture.PNG

JIRA Version: 6.0

Gave error when I tried to run the script.

Vasiliy Zverev Community Champion Feb 04, 2016

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

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

93 views 0 1
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you