Modify notification settings for all users

Issue

Team members have reported receiving email notifications for any update or discussion started on a review item in Prolaborate.

Workaround

1. The normal workthroughis to ensure each user adjusts their notification settings to "Participated" in Prolaborate. Users can find this option in the menu under "Notification Settings," as shown in the image below.

2. If it's not feasible to inform all users individually, administrators can execute the provided query in the Prolaborate database to modify the notification settings for all users. Please ensure to replace 'dbname' with your actual Prolaborate database name before executing the query.

For MySQL:

update dbname.generalsettings set value=0 where Name='Notify_SendEmail';

update dbname.generalsettings set value=1 where Name='Notify_NewDiscussion';

update dbname.generalsettings set value=0 where Name='Notify_UpdateDiscussion';

update dbname.generalsettings set value=1 where Name='Notify_Replies';

update dbname.generalsettings set value=0 where Name='Notify_CollaborationLikes';

update dbname.generalsettings set value=0 where Name='Notify_ReviewInvite';

update dbname.generalsettings set value=0 where Name='Notify_ReviewRoleChange';

update dbname.generalsettings set value=1 where Name='Notify_ReviewScopeChange';

update dbname.generalsettings set value=1 where Name='Notify_CollaborationNotification';

update dbname.generalsettings set value='WEEKLY' where Name='PeriodicMail';

update dbname.generalsettings set value=0 where Name='DayOnWeek';

For MSQL:

update dbname.dbo.GeneralSettings set value=0 where Name='Notify_SendEmail';

update dbname.dbo.GeneralSettings set value=1 where Name='Notify_NewDiscussion';

update dbname.dbo.GeneralSettings set value=0 where Name='Notify_UpdateDiscussion';

update dbname.dbo.GeneralSettings set value=1 where Name='Notify_Replies';

update dbname.dbo.GeneralSettings set value=0 where Name='Notify_CollaborationLikes';

update dbname.dbo.GeneralSettings set value=0 where Name='Notify_ReviewInvite';

update dbname.dbo.GeneralSettings set value=0 where Name='Notify_ReviewRoleChange';

update dbname.dbo.GeneralSettings set value=1 where Name='Notify_ReviewScopeChange';

update dbname.dbo.GeneralSettings set value=1 where Name='Notify_CollaborationNotification';

update dbname.dbo.GeneralSettings set value='WEEKLY' where Name='PeriodicMail';

update dbname.dbo.GeneralSettings set value=0 where Name='DayOnWeek';

Note: This query will not work for users who have manually changed their notification settings in the previous version.

After executing the query, users not involved in a discussion will not receive any emails related to discussions they are not a part of. Users can manually adjust their notification settings if they wish to receive notifications based on their preferences.