How to Update all User Profiles for the Notify Me option

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Looking for a way to change all user profiles to change their notification settings at once.

Diagnosis

By default all users start with preferences to not be notified by their own updates.  Sample profile screenshot:

Workaround

As of JIRA 5.2.2, the Autowatch functionality can now be disabled, as tracked in JRA-28268 - Getting issue details... STATUS . Please upgrade to the latest JIRA version to pick up this functionality. Alternatively, the below SQL update may be used:

Always back up your 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:
written in postgres
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';

(info) This SQL may need to be modified depending on the DBMS that is used by JIRA.

Last modified on Feb 23, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.