How do I set "Showed Changed Content" to false for entire Confluence installation?

For security reasons we cannot send out the full content of blog posts in email when notifications go out. As such we've had to shut down all email notificaitons from blog posts within confluence. I know that each individual user can manage their email notifications, but we'd like to enforce this firm wide.

I'm referring to the "Show changed content" referenced here

Is this a setting we can enforce for all users?

1 answer

1 vote

Howdy Jonathan!

There is a way to enforce this setting for all users, but it will involve working in the database. This information is stored in the OS_PROPERTYENTRY table. You can manually disable the "show changed content" setting for all users that have email notifications enabled by running the following SQL statement:

SET boolean_val = 'f'
WHERE entity_key = '';

After manually setting all users to false, you can then use a stored procedure or a trigger to set that value to false if a user attempts to enable the setting.

As this involves directly modifying the database, ensure you backup the database before making any changes. Also note that this statement would not be officially supported by Atlassian.


Stephen Brannen | Confluence Support

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Thursday in Confluence

Three common content challenges + how to manage them

An efficient enterprise content management system, or ECM, is a must-have for companies that create work online (cough   cough, all companies). If content calendars, marketing plans, and bu...

87 views 0 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you