How to remove a subscription

[rakhi]

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?

[Mark Symons · Accepted solution]

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

[John Durrett]

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.

[Valentijn Scholten]

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

[Sachin Ambulkar]

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.

[Rumceisz]

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.

[Eva]

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]

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]

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]

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

[Jirong Hu]

Can only change owner or delete them.