Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,316
Community Members
 
Community Events
165
Community Groups

How to disable issue filter subscriptions for all users

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

francis Marketplace Partner Oct 04, 2020

Nice one @Koen Gillard 

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

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

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

Like # people like this

This didn't do anything? 

It should to delete all subsriptions.

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

Capture.PNG

 

FYI: JIRA Version: 7.0.5

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()
Like Asaf.Porat likes this

JIRA Version: 6.0

Gave error when I tried to run the script.

Capture.PNG

JIRA Version: 6.0

Gave error when I tried to run the script.

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
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

174 views 1 3
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you