b) update USER_PREFERENCES set SURVEY_EMAIL_COMMUNICATION=1

c) update USER_PREFERENCES set SURVEY_PHONE_COMMUNICATION=1 (This enables the survey push notification)




3. To Update Social Activity Email Notification.

a) update USER_PREFERENCES set FEED_NOTIFICATION_METHOD = 1 (Only for email notification)
b) update USER_PREFERENCES set FEED_NOTIFICATION_METHOD = 3 (For Email & Push notification)

0 will disable both email and push notification
2 will only enable push notification

4. To update Service Health notifications which are introduced newly from 21.3.x onwards.

update dwp_userpreferences set servicehealthemailcommunicatio = 0, servicehealthpushcommunication = 0; (0- Disable, 1- Enable)

Note: The field name in the 'dwp_userpreferences' view for email notification is 'servicehealthemailcommunicatio' but in the DB table it is 'servicehealthemailcommunication'.


To update Inline Notifications for Request notifications

1. update dwp_notificationpreferences set enabled = 0 where Type = 'Request' and keyname in ('IN_PROGRESS', 'CLOSED');

TO update inline notifications for Approval.

update dwp_notificationpreferences set enabled = 1 where type = 'APPROVAL' and keyname in ('MESSAGES_ON_REQUEST', 'WAITING_FOR_APPROVAL', 'ALTERNATE_APPROVAL', 'MESSAGES_ON_REQUEST' , ''MESSAGES_ON_COMPLETED_APPROVALS'');


DB Query for DWP v21.x is the following:

Update dwp_UserPreferences set broadcastpushnotification  = 0,feednotification  = 0,feednotificationmethod  = 0,SrEmailCommunication = 0,SrPhoneCommunication = 0,SurveyEmailCommunication = 0,SurveyPhoneCommunication = 0,ApprovalEmailCommunication = 0,ApprovalPhoneCommunication = 0,BellCommunication = 0, servicehealthemailcommunicatio  = 0,servicehealthpushcommunication  = 0

DB Query for DWP v22.x is the following:

- To enable the existing users use the below query:

update dwp_userpreferences set bellcommunication = 1,
       servicehealthemailcommunicatio = 1, servicehealthpushcommunication = 1,
       surveyemailcommunication = 1, surveyphonecommunication = 1,
       approvalemailcommunication = 1, approvalphonecommunication = 1,
       feednotification = 1, feednotificationmethod = 3,
       sremailcommunication = 1, srphonecommunication = 1,
       broadcastpushnotification = 1

update dwp_notificationpreferences set enabled = 1

- For new users the below documentation helps to bulk update the notifications:
https://docs.bmc.com/docs/digitalworkplaceadvanced/213/configuring-status-updates-and-notifications-1013447750.html