Query Builder Dialog Box

Relevant for: API testing only

This dialog box helps you create an SQL statement for the Query string property of the Database > Select Data activity.

To access

Do the following:

  1. Drag a Database > Select Data activity onto the canvas.
  2. Click the Input/Checkpoints tab in the Properties pane.
  3. Select the Input property—Query string.
  4. Click the Query Builder button in the right side of the Value column.

User interface elements are described below (unlabeled elements are shown in angle brackets):

UI Elements

Description

Query Designer. Opens the Query Designer dialog box. For details, see the Query Designer Dialog Box.
Query string

A drop-down list of previously defined query strings.
<query string area>

An editable area for pasting in existing strings, or for editing the query string selected in the drop-down list.
Test Query

Tests the query against the database to which you are connected.
<query status>

The displayed query's status. The possible values are:

  • Query not executed
  • Query executed successfully
  • Query completed with errors
Generate output

Automatically retrieves table information from the database when you click OK, and sets the structure of the output in the Properties pane's Checkpoints area.