When a content editor edits a page but does not submit it for review, they get an email notification. This article details how to disable email notifications being sent to users for a workflow state change.
- Access to a SuperUser Account.
In order to disable the email notifications for a specific state (Draft, Ready For Review and Published), you would need to set the sendNotification column to False which is 0 for boolean value in the ContentWorkflowStates table. This can only be done through the database, as there is no option in the UI.
Note: To maintain best practices, make sure to backup your database before doing any change to it.
- Go to Settings > SQL Console and execute the below script
SET SendNotification = 0
WHERE StateName = 'Desired_State'
AND WorkflowID = (Select WorkflowID
WHERE WorkflowName = 'Content Approval'
AND PortalID = [PORTAL ID GOES HERE])
Once you run this script, you need to clear the cache.
To test that the notification has been disabled:
- Login any user with Edit permissions for a page.
- Make a change on the page.
You should not get an email notification for making a change on the page.