To create a query with Point & Click

These instructions explain how to create a query using the Point & Click feature in a Process Configuration dialog.

To edit a query, double-click any item in the query to select another value. Selecting a new item from the Select Based On drop-down list will remove the existing query.

1.	In a process that uses queries, such as Segment, Select, or Extract, access the process configuration dialog where queries can be constructed. For example, open a Select process box and click Select Customer IDs) with on the Select tab.

By default, the Point & Click query builder is displayed.

2.	To create a query, click in each column cell (Field Name, Oper., Value, And/Or), then double-click a selection from the list on the right. If the Profile option appears, you can use it to display the values in the field.

By clicking in each column, then double-clicking a selection, you can build your query:

Use Field Name to indicate which field to query. You can select from the list of Available Fields, including IBM® Unica® Campaign Generated Fields. You can also create Derived Fields.

Use Oper. to select a comparison operator (for example, =, <, >, Between).

Select a Value for the field.

To add another expression, click the And/Or column, then double-click AND or OR to indicate how to combine the expressions.

To add parentheses to control evaluation order, select an expression, then use 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').

Select one or more expressions, then use Move Up or Move Down to reorder expressions.

Select an expression then use Insert to add a blank row.

3.	Click Check Syntax to confirm whether your query syntax is valid. Checking the syntax does not put any load on the database server.

Campaign indicates whether the syntax contains any errors.

4.	To see the results of the query, click Test Query.

Global suppressions and cell size limits are not applied in Test Query counts. Queries might also return non-normalized data. To obtain an accurate result count, test run the process.

A progress bar is displayed while the query is being tested. Click Cancel to stop the testing.

When testing is complete, Campaign indicates the number of rows the query returned. (This number might be different when the campaign is run.)

Click OK.