To create a query with Text Builder

These instructions describe how to create a new query using the Text Builder feature in the process configuration dialog.

To edit an existing query, edit the text of the query directly in the query text box.

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.	Click Text Builder.

The Point & Click query columns are replaced with a blank text box.

3.	Choose an Input data source, and a data source to query from the Select Based On drop-down list.

The list of Available Fields is displayed based on your Select Based On choice.

4.	Create your query by:

Selecting the field or table name(s) from the Available Fields list and double-clicking to enter them in the query text box. You can also click once then click <-Use to move it to the query text box.

Entering the required operators and values. To see the values of a selected field, you can click Profile.

Although you can enter field and table names directly in the query text box, selecting them from the list helps to avoid syntax errors.

5.	To check the syntax of the query, click Check Syntax.

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

Checking the syntax of your query does not put any load on the database server.

6.	If you want 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 run.)

7.	When you have finished creating your query, click OK.

The process configuration box closes and you are returned to the flowchart page in Edit mode.