Use this form to create and combine queries in order to generate a list of contact persons for the active campaign.

You can base a campaign contact person target selection on a single query or on combined queries.

Tasks that use this form

Example

Query A consists of contact persons from business relation X, while query B consists of contact persons from business relation Y.

Drag query A to the drop area, click the plus sign (+), drag query B to the drop area, and then click Execute.

All contact persons from business relation X and Y will now be displayed in the grid in the Expression resultarea.

Click the OKbutton to transfer all targets to the Campaignsform.

Form layout

The Targetform consists of three areas: Queries, Drop area, and Expression result.

Area	Description
Queries	Create and adjust the queries that filter the tables ( Call list, Business relation, Sales order, Quotations, Questionnaire, Mailings, Contact Interest, Contacts, Campaign selections) in this area. You can specify filter fields and sort order when creating the query, and then define values in the filter fields to simplify selection from the tables. Queries can be saved and reused by the same campaign or deleted after the contact persons are found and the target list created.
Drop area	Combine the various query results using logical operators such as AND, OR, and the + and - functions in this area. By combining you can create desired subsets of data based on simple queries, which reduces the need to create complex, inter-dependent queries.
Expression result	Examine and adjust the final result of the campaign target selection process in this area, adding or deleting contact persons, or changing the contact person for a particular business relation.

Area

Description

Queries

Create and adjust the queries that filter the tables ( Call list, Business relation, Sales order, Quotations, Questionnaire, Mailings, Contact Interest, Contacts, Campaign selections) in this area.

You can specify filter fields and sort order when creating the query, and then define values in the filter fields to simplify selection from the tables.

Queries can be saved and reused by the same campaign or deleted after the contact persons are found and the target list created.

Drop area

Combine the various query results using logical operators such as AND, OR, and the + and - functions in this area.

By combining you can create desired subsets of data based on simple queries, which reduces the need to create complex, inter-dependent queries.

Expression result

Examine and adjust the final result of the campaign target selection process in this area, adding or deleting contact persons, or changing the contact person for a particular business relation.

Navigating the form

The following tables provide descriptions for the controls in this form..

Buttons

Area	Buttons	Description
Queries	Run query	Run the active query.
Queries	View query result	View and adjust the query and field delimiters.
Drop area	+	Enter +in the Expressionfield to add a query result to the preceding query result.
Drop area	-	Enter -in the Expressionfield to subtract a query result from the preceding query result.
Drop area	(	Enter (in the Expressionfield to start a separate logical expression.
Drop area	)	Enter )in the Expressionfield to end a separate logical expression.
Drop area	AND	Enter ANDin the Expressionfield to limit a logical expression.
Drop area	OR	Enter ORin the Expressionfield to combine a logical expression.
Drop area	Clear	Delete all query results and logical operators from the Expressionfield.
Drop area	Execute	Run the logical expression in the Expressionfield.
Expression result	Clear	Delete campaign targets from the Expression resultgrid.

Fields

Field	Description
Campaign ID	Unique identification (ID) for the campaign.
Query name	Name of the campaign query.
Description	Describes the query.
Expression	Expressions created based on the campaign queries.