• Email->Enabled
• Push->Enabled
• All Status Updates Enabled under Approval Notifications

• Email->Enabled
• Push-> Enabled
• Under Request Notification ,Only Submitted and Completed Status needs to be enabled and rest options should be disabled.

This can be achieved using below DB commands for existing DWP users:

A)Take a backup of the tables as per below:
1) select * from dwp_notificationpreferences
2) select * from dwp_UserPreferences
 
B)Run below Update Queries in Sequence:
1)Enable "Approval" All Status notification:

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')

5) Enable Request Email and Push Notification:

update dwp_UserPreferences set SrEmailCommunication =1,SrPhoneCommunication =1

 
Approve, Reject, On Hold, Reassign Approval are the only standard options available in DWP as designed behavior. We cannot customize to add new values to this.
 

We have another way to update the user preferences from dwp:UserPreferences Innovation Studio form.

1. Open dwp:UserPreferences form
2. Search for the user record and update below mentioned options according to our requirements
3. Set ApprovalEmailCommunication and ApprovalPhoneCommunication True for approval notifications.
4. Set SrEmailCommunication and SrPhoneCommunication True for Request notifications.
5. Set SurveyEmailCommunication and SurveyPhoneCommunication True for Survey notifications
6. Click on Save