How to remove a subscription

rakhi December 19, 2011

how do we remove the old, hidden and active subscription. I am getting duplicate emails for the subscription and my guess its coming from an instance which is not in use.
I see the entries in the database (Test) but wondering if it is safe to remove it from 'FilterSubscription' Table , would it impact any other tables?

6 answers

1 accepted

2 votes
Answer accepted
Mark Symons
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 12, 2012

1) There is an existing logged JIRA issue..

JRA-7404: "No way to delete subscriptions that aren't yours!"

2) This issue has been open a long, long time so I am not holding my breath waiting for a fix. But in the mean-time, might it not be possible to write a Groovy script that would change ownership of subscriptions?

3) It should be perfectly safe to remove subscriptions from the 'filtersubscription' table in the database, as this is a documented step in configuring a staging environment:

Modify your staging environment for the unique configurations

1 vote
John Durrett August 6, 2018

1. Login to Jira Site

2. Bring up list of filters you are watching.

3. Click on Filter in question you no longer wish to receive emails from.

4. To right of Filter name are two choices - Save As and Details.

5. Click on Details link

6. Bottom of Details dropdown is Subscription - Click Manage Subscriptions

7. On new window - on right hand side click hyperlink for "Delete".

You will no longer receive email for this Filter.  As there are several subscription options per filter you may need to delete multiple subscriptions for same filter.

0 votes
Valentijn Scholten
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 11, 2013

I know this is an old issue, but can't you just disable sending emails all together for your staging environment?

Using -Datlassian.mail.senddisabled , see: https://confluence.atlassian.com/display/JIRA/Setting+Properties+and+Options+on+Startup

0 votes
Sachin Ambulkar December 12, 2012

can some be more specific and tell me what query we need to run to get rid of subscription email on staging environment.

Thank you in advance.

0 votes
Rumceisz June 3, 2012

Hi All,

I have the same problem: I get duplicated emails from a subscription. I only have one user account gfor my email address. What can be the problem.

I get these emails in the same minute.

0 votes
Eva
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 17, 2012

If you are using 4.4.1 above, you should be able to go to admin, and modify the subscription.


Doing it in DB isnt that safe unlses you are absolutely sure. you also need to reindex the whole JIRA aftewward, which will required downtime.

rakhi March 26, 2012

I have deleted the subscription filter but its still sending the emails to the users. IS there any other way we can find out why it is sending emails when that filter does not exist anymore?

Ubisoft
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 26, 2012

I have already removed data in FilterSubscription table on our production environement successfully without impact since it has no other link.

Martin Poirier

Ubisoft Montreal

Jirong Hu July 21, 2015

No, as an admin, I still can't find a way to delete the subscribers.

Jirong Hu July 21, 2015

Can only change owner or delete them.

Suggest an answer

Log in or Sign up to answer