email routing rules

[chriscorcoran]

is it possible to have more than one  Rule Expression, so I want to take inbound emails from a specific domain with a specific subject, ideally contains specific words in a subject would be better.

so the Rule Expression would be something like fromAddress = 'ABC@domain.com' subjectContains ='orangesandlemons' does that work?

[Steve Giller]

The syntax is very similar to a SQL WHERE clause, so you'd need to use AND between them, but it looks about right.

[Gerry]

@chriscorcoran

From what you have described, something along these lines...

fromAddress LIKE '%@domain.com' AND subject LIKE '%orangesandlemons%'

ought to do it.  Basically, as @Steve Giller says, this expression syntax is SQL-like in its syntax.   The above will match any from address where the domain is @domain.com and where the word 'orangesandlemons' is contained within the subject.

The documentation you need is here:  https://wiki.hornbill.com/index.php?title=Inbound_Routing_Rules

Gerry

[HHH]

@chriscorcoran From experience I found that AND takes preference over OR
so  A OR B AND C would be interpreted as A OR (B AND C) so if you want (A OR B ) AND C you need to use parenthesis

[Gerry]

Relevant...

 

SQL Operator Precedence refers to the order in which different operators are evaluated in an SQL statement. When an SQL query contains multiple operators, the operator precedence determines the sequence in which they are executed to evaluate the expression.

Here is a typical operator precedence hierarchy in SQL, starting from the highest precedence to the lowest:

1. Parentheses: Operators enclosed in parentheses are evaluated first. Parentheses can be used to explicitly control the order of evaluation.

2. Unary Operators: Unary operators, such as the negation operator (-) or logical NOT operator (NOT), have higher precedence than binary operators.

3. Multiplication, Division, and Modulo: Operators like multiplication (*), division (/), and modulo (%) have higher precedence than addition and subtraction.

4. Addition and Subtraction: The addition (+) and subtraction (-) operators have the same precedence and are evaluated from left to right.

5. Comparison Operators: Comparison operators, such as equality (=), inequality (<> or !=), greater than (>), less than (<), etc., are evaluated after arithmetic operators. They are used to compare values and return a Boolean result.

6. Logical Operators: Logical operators, such as AND, OR, and NOT, are evaluated after comparison operators. They are used to combine multiple conditions and return a Boolean result.

It's important to note that the actual operator precedence may vary slightly depending on the specific database management system (DBMS) being used. Therefore, it's always a good practice to use parentheses to explicitly group expressions and clarify the desired order of evaluation, especially when combining different operators in complex queries.