Policy Guide › Data Lookup › Complex Data Lookup Commands

Complex Data Lookup Commands

For precision targeting of specific emails, you can use AND, OR and NOT operators and parenthesis to define more complex Data Lookup commands. These enable you to include multiple True-False tests within a single command or link separate commands. But first note the rules governing command evaluation.

Command Evaluation

CA DataMinder evaluates lookup commands from left to right. This is particularly important if your lookup command contains three or more True-False tests and if you use brackets to set evaluation precedence. Note that we do generally recommend you use brackets when combining multiple lookup commands. The examples below show how three logical tests (A, B and C) combine to produce an overall result:

When you combine multiple lookup commands, CA DataMinder quits evaluating as soon as it detects any subcommand that allows the overall command to be unambiguously resolved. Specifically, this affects:

• Any instances where the first subcommand returns False (because this sets the overall command to False, so the trigger does not activate).
• Subcommands linked with an OR operator. Here, CA DataMinder quits evaluating if any subcommand returns True (because this sets the entire command to True and activates the trigger).

In examples 2 and 3 above, if A, B and C represent linked commands, then commands B and C are not evaluated because, with command A returning True, the overall command must also return True. This is a deliberate optimization designed to minimize delays when processing outgoing emails.

Note: This optimization does not apply to multiple True-False tests within a single lookup command. In this case, all tests are fully evaluated.