How to Update all User Profiles for the Notify Me option
Looking for a way to change all user profiles to change their notification settings at once.
By default, all users start with preferences to not be notified of their own updates. Sample profile screenshot:
- How to stop being automatically added to the watcher's list when working on issues? For both Cloud and Server
Please upgrade to the latest JIRA version to pick up this functionality. Alternatively, the below SQL update may be used:
Alwaysyour data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
- The tables you'll compare are: external_entities, propertyentry, propertystring
- Here is a sample SQL query that will pull the information you need to write a SQL update:
select x.name,e.property_key,n.propertyvalue from propertyentry e join propertynumber n on e.id=n.id join external_entities x on e.entity_id = x.id where e.property_key = 'user.notify.own.changes';
This SQL may need to be modified depending on the DBMS that is used by JIRA.