Disable all user filter subscriptions when user account is de-activated

Summary

Email Filter Subscriptions are still sent after an user is marked as deactivated.

Steps to Reproduce

1. Create an user belonging to jira-users group
2. Deactivate the user
3. Create a filter and subscribed to jira-users group
   • Filter used: issuekey in issueHistory() ORDER BY lastViewed DESC
   • Ticked the option to still send an email even there's no issue found.

Expected Results

JIRA would send subscriptions only to active users.

Actual Results

All users belonging to the jira-users group receive the filter subscription email, regardless of being deactivated.

Notes

This happens both when deactivating the user by unchecking the 'Active' checkbox in the user edit screen, or removing the user from all groups.

Workaround:

Some sql queries would need to remove the filter subscriptions from the database with the reference:

• http://wiki.customware.net/repository/display/ATLASSIAN/How+to+delete+filters+and+subscriptions+added+by+other+users