How can I enable DWP User Preference Notification using the following criteria for all users? Notification Setting criteria: 1)Approval:
2) For Request Notifications:
How can I add more options to the Approval Request apart from the below |
This can be achieved using below DB commands for existing DWP users: update dwp_notificationpreferences set enabled = 1 where type = 'APPROVAL' and keyname in ('MESSAGES_ON_REQUESTS', 'WAITING_FOR_APPROVAL', 'ALTERNATE_APPROVAL' , 'MESSAGES_ON_COMPLETED_APPROVALS') 2)Enable "Approval" Email and Push Notification update dwp_UserPreferences set ApprovalEmailCommunication=1,approvalphonecommunication=1; 3)Disable "Request" Status Change notification for status ('IN_PROGRESS','WAITING_FOR_APPROVAL','CANCELLED','CLOSED','SHARED_REQUESTS','REJECTED','MESSAGES_ON_REQUESTS','FAILED'): update dwp_notificationpreferences set enabled = 0 where type = 'REQUEST' and keyname IN ('IN_PROGRESS','WAITING_FOR_APPROVAL','CANCELLED','CLOSED','SHARED_REQUESTS','REJECTED','MESSAGES_ON_REQUESTS','FAILED') 4)Enable "Request" Status Change notification for ('COMPLETED','SUBMITTED'): update dwp_notificationpreferences set enabled =1 where type = 'REQUEST' and keyname IN ('COMPLETED','SUBMITTED')
update dwp_UserPreferences set SrEmailCommunication =1,SrPhoneCommunication =1
We have another way to update the user preferences from dwp:UserPreferences Innovation Studio form.
|