Need to restrict transaction in sys email table

[kun1]

Hi Team,

we have a requirement to abort the transaction in email table

Suppose we have 4 companies and we dont want sent notification to all 4 companies as we are not live with all 4 company customers. We need to abort the email to the companies for which we are not live.

For solution , We can create a custom field on company table called enable notification(true/false) and if enable notification is true then only notification will send to sys email table.

Target table is Incident or request 

Is there any way to achieve this so that it will not impact the system 

[Robbie]

Hi @kun1,

So you have a couple of options here.

Implementing a solution using Out Of Box fields and functionality, there is a 'Notification' field on the user table (and contact table if using CSM) where you can either 'Enable' (Default value) or 'Disable' emails from being sent.

The update for you would be to implement a Business Rule (and a one of update to existing user/contact records) where a user is associated to one of the said companies you do not wish to send an email to, the Notification field should be set to disable.

My only problem with this considering the sensitivity around emails would be what happens if users aren't associated correctly or associated after an event is triggered.

For this reason, I'd also use a belt and braces solution to ensure an email cannot be sent under said conditions by implementing a before insert business rule on the sys_email table itself. Here you can control exactly what should be sent and loop through the intended recipients before sending.

To help others (and for me to gain recognition for my efforts), please mark this response correct by clicking on Accept as Solution and/or Kudos.



Thanks, Robbie

[kun1]

What is the belt and braces solution? 

Can you share the business rule on sys email table to restrict it ?

[kun1]

Hi @Robbie ,

Any update on this thread?