Reference for DPA Advanced Rules - EnterWorks_Process_Exchange_(EPX) - 11.0

To create Advanced rules you can use numbers, strings, collections, datetimes and dates. Operators such as: +, -, *, /, =, >, <, >=, <=, <>, and = are valid. You can also use functions in your Advanced rules.

Valid Formats

Variables

For example, if the variable is a number, type:

Number:varName 

For strings and dates, type:

String:varName and Date:varName 

For a datetime type:

Datetime:expiredDate or Datetime:sendDate

Operators

The set up of advanced rules with operators must follow the correct syntax. Parameters (data type prefix and variable pair) should always be placed within parentheses to pass validation. For example:

Number:a=(Number:b)+(Number:c)-(Number:d)*(Number:e)/(Number:f)

Examples of advanced rule operator usage:

Functions

Available functions are: max, absolute, length, and date. Place functions on the right-hand side of the expression. For example:

abs(3)=max(3,5)

This example is not valid, because the function abs (absolute) is to the left of the equal sign (=).

Another example:

5=max(5,5) 

This example is valid, because the function, max, is to the right of the equal sign (=).