|
For a Select process, choose Select <audience> IDs With.
|
|
For a Segment process, use Segment by Query, double-click a segment to edit it, then use Select IDs With.
|
|
For an Extract process, use Select records With.
|
a.
|
To specify which field to query, click in the Field Name cell. The Available Fields list should appear. If the list does not appear, click in the Field Name cell again. Select an available field by double-clicking it or highlighting it and clicking Use. When deciding which available field to use, you can highlight a field and click Profile to see a list of field values.
|
b.
|
You can use the Derived Fields button if you want to create or select an existing variable for querying.
|
c.
|
Click in the Oper cell, then double-click a comparison operator in the Operators list (such as =, <, >, Between).
|
d.
|
Click in the Value cell, then double-click a value. If no values appear, click Profile to see a list of field values. You can also double-click in the Value cell to edit the value directly.
|
|
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 Expressions area.
|
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.
|
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.
|
5.
|
Click Check Syntax to confirm whether your query syntax is valid. Checking the syntax does not put any load on the database server.
|
6.
|
7.
|
Copyright IBM Corporation 2015. All Rights Reserved.
|