Expression Builder
The Expression Builder enables you to use pre-built DataFlux expressions to create one or more checks for a business rule. The pre-built expressions are divided into four categories:
Compare Entire Field
Compare a field to a value or another field
- The following operations are available for both numeric and text types <, > =<, =>, =, and !=. For text types, an alphabetical comparison is performed.
- Text comparison with the ability to perform trim, case sensitivity, and wild cards is available.
Compare a field value to list of values
- The following options are available: = and !=.
- You can import values from a table or from a formatted text file (one entry per line).
- Text comparison with the ability to perform trim, case sensitivity, and wild cards is available.
Compare a field to a field in a data source
- Checks to see if the field matches or does not match the value of a field in a data source (data source type).
Compare a field to a reference data domain
- Checks to see if the field value matches or does not match a value in Reference Data Management domain. The check works only with Reference Data Management domains of type List.
Determine if a field is inside or outside a range of values
- The operators are inside or outside a set.
- Text comparison with the ability to perform trim, case sensitivity, and wild cards is available.
Determine how a field differs (amount/percentage) from another field
- The following operations are available for both numeric and text types <, > =<, =>, =, and !=.
- For text types, it performs an alphabetical comparison.
- The difference can be an amount or percentage.
Determine if a field matches a pattern or regular expression
- The operators include match and does not match.
- Regular expressions are available for comparison.
Compare Portion Of Field
Compare a portion of a field to a value
- The following portions are available: leftmost, rightmost, character X to character Y (X, Y are numbers), and character X through the end (X is a number).
- The following operations are available for both numeric and text types <, > =<, =>, =, and !=. For text types, it performs an alphabetical comparison.
- Text comparison with the ability to perform trim, case sensitivity, and wild cards is available.
Determine if a field begins with, ends with, or contains a value
- The following options are available: begins with, ends with, contains, and does not contain.
- The case sensitivity can be determined.
Compare part of date field to a value
- The following date parts are available: month, day, year, hour, minute, and second.
- The following options are available for both numeric and text types <, > =<, =>, =, and !=.
Get Field Information
Get information about the contents of a field
The following options are available: is/is not, null, alphabetic, alphanumerical, and control characters.
Check the case
The following options are available: is /is not lower, uppercase, and mixed case.
Compare the length of a field equal to
- The following operators are available: <, > =<, =>, =, and !=.
- You can combine these built-in checks using AND/OR logic.
If the pre-built expressions do not fulfill your business needs, you can add custom metrics to a business rule.