To create a query with Point & Click

These instructions describe how to create a new query using the Point & Click feature in the process configuration dialog.

To edit an existing 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 requires queries, such as Segment, Select, or Extract, access the process configuration dialog containing the query text box.

By default, the Point & Click query builder is displayed. Any existing queries are shown in the query text box.

2.	As you click in each of the columns in the left text area (FieldName, Oper., Value, And/Or), the options that you can select for the selected column appear in the box on the right.

Click the Field Name column to see the list of Available Fields, including IBM® Unica Campaign Generated Fields. You can also click Derived Fields... to create derived fields.

Click the Oper. column to see the list of Operators;

Click the Value column to see the possible values based on your selection from Field Name;

Click the And/Or column to see AND and OR as Operators. Use this column to create multiple statements;

Select the entire expression to see the actions you can perform For Selected Expressions: Add, Remove, Clear all, Move Up, Move Down, Insert, and Delete.

3.	Create your query by clicking in each column cell in the left text area, then double-clicking to make your selection from the list on the right. You can also click once, then click <-Use to move it to the left text box.

When you select a table field, you can click Profile to review the values of the selected field.

4.	To check the syntax of the query, click Check Syntax. Checking the syntax of your query does not put any load on the database server.

Campaign displays a confirmation window that displays any found errors. Click OK.

5.	To see the results of running 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, perform a test run of the process.

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

When testing is complete, Campaign displays a confirmation window that displays the number of rows the query returned. (This number might be different when the campaign is actually run.)

6.	When you have fnished creating your query, click OK.