To create a query using Query Helper

The Query Helper provides selectable operators and functions that you can combine with available fields to build a query. The Query Helper can help you construct queries in Campaign’s macro language or with custom macros.

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. The Query Helper button is enabled.

3.	Click Query Helper.

The Query Helper appears below the query text box. The Query Helper contains a set of buttons for inserting commonly used operators, and a complete list of macros.

4.	Create your query by:

a.	Selecting the macro you want to use from the list of macros in the Query Helper and double-clicking to enter it in the query text box. When you select a macro, the Query Helper displays a brief description and the syntax of the selected macro.

If you select a custom macro, the description and syntax were created by the person who wrote the macro.

b.	Entering the required operators by typing or using the Query Helper buttons.

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.	Continue creating your query using the Text Builder.

6.	When you have finished creating your query, click Close.

The Query Helper closes.

7.	Click OK to close the process configuration dialog.