Unica Campaign V12.0 User Guide | 3 - Designing flowcharts | 121
Note: When the list of Available fields is displayed, you can use the Derived
fields button if you want to create or select a variable for querying. For more
information, see Derived fields (on page 279).
b. Click in the Oper cell, then double-click a comparison operator in the Operators list
(=, <, >, <=, >=, <>, In, Not in, Between).
c.
Click in the Value cell, then double-click a value. If no values appear, double-click
(Profile...) in the Values list to open the Profile selected field dialog so you can
select from a list of values. You can also double-click in the Value cell to edit the
value directly.
Note: If you do not see the expected list (Available fields, Operators, Values,
For selected expresssion), try either single clicking or double clicking on a cell in
the Expression area.
You now have an expression that consists of a field name, operator, and value.
9. Click Check syntax to confirm whether the query syntax is valid. Checking the syntax
does not put any load on the database server.
10.
To add and combine multiple expressions, follow the guidelines below:
a. To add another expression, click the And/Or cell, then double-click AND or OR in
the Values list to indicate how to combine the expressions.
b. Build your next expression, consisting of a field name, operator, and value.
c. To add parentheses to control evaluation order, double-click the Field Name in
any row to display the For selected expression list. In the list of expressions,
double-click Add ( ) to add a set of parentheses, Remove ( ) to remove a single
set of parentheses, or Clear all ( ) to remove all of the parentheses in the selected
expression. Parentheses allow you to group expressions when defining complex
queries. For example, (AcctType = 'Gold' AND Rank = 'A') OR NewCust = 'Yes' is
different from AcctType = 'Gold' AND (Rank = 'A' OR NewCust = 'Yes').
d. To reorder the selected expression, double-click Move up or Move down.
e. To add a blank row below the selected expressions, double-click Insert.