Jump to content

Email Routing Rules


Jeremy

Recommended Posts

When you have routing rules configured to process emails in your instance you might find the rules do not process (all or some) emails. This can be caused by an incorrect syntax configuration of the expression criteria for routing rules. As a general rule, expressions used in routing rules follow the syntax used in SQL expressions. Here is a list of the most common misconfigurations:

The string/character values used in expressions are not enclosed within quotes. For example, a criterion like fromAddress = example@domain.com is incorrect. It needs to be configured as fromAddress ="example@domain.com" (the values used to match the fromAddress criterion needs to be enclosed in quotes)

The string/character values used in expressions are not fully enclosed within quotes. For example, a criterion like fromAddress = "example@domain.com is incorrect. It needs to be configured as fromAddress = "example@domain.com" (the values used to match the fromAddress criterion needs to be fully enclosed in quotes)

The string/character values used in expressions are enclosed with a mix of single and double quotes. For example, a criterion like fromAddress = "example@domain.com' is incorrect. It needs to be configured as fromAddress = "example@domain.com" or fromAddress = 'example@domain.com' (the opening quotes used to enclose the values need to match the ending quotes for that value)

When using the LIKE operator the value does not contain a wildcard. When using the LIKE operator in a criterion to match specific patterns, the value needs to contain at least a wildcard otherwise the operator will evaluate as a hard match (equal). For example, a criterion like subject LIKE "test" will evaluate as subject = "test" because the value used for LIKE evaluation does not contain any wildcard. If you need your expression to match the value as a pattern within the evaluated parameter (for example, the email subject) then the expression needs to be as follows:

  • subject LIKE "%test%" (to match the value anywhere within the evaluated parameter - e.g. subject contains...)
  • subject LIKE "test%" (to match the value at the beginning the evaluated parameter - e.g. subject starting with...)
  • subject LIKE "%test" (to match the value at the end the evaluated parameter - e.g. subject ending with...)

Important: when evaluating toDomain, toAddress or ccAddress parameters always use the LIKE operator. This will ensure the routing rule will match the email even if it is addressed to multiple recipients. If the criterion is using the equal operator for these parameters instead of LIKE and the email is addressed to multiple recipients, the routing rule will not match the email.

 

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...