Building expressions using the Expression Builder

The Expression Builder is used throughout Opportunity Detect to compare strings and numbers, perform math operations, and apply database functions.

The Expression Builder uses standard mathematical syntax. String constants must be surrounded by double quotes.

For operands, you can enter constant values using the keyboard, or you can use the Value Selector to specify the following.

  • Field values from a transaction or profile data source.

    If a Named Value list is configured for a field, you must use the Value Selector to add the value.

  • Values calculated in expression components.
  • Field values from records returned by a Select or Container component.

Your choices differ depending on the component you are working with, and on the data type you select.

CAUTION: If you enter an operand using the keyboard, and you insert an extra space between operands, the expression does not validate even if you remove the extra space. You must clear the expression and create it again.