DataFlux Data Management Studio 2.6: User Guide

Where Tab

You can use the Where tab to specify an expression for a WHERE clause. A WHERE clause specifies a condition that the data must satisfy before being selected.

The Filters section of the Where tab contains a toolbar that performs the following functions:

• Auto-generating the default filters for the join (based on the selected tables and the join type)
• Adding, editing,and deleting filters in the filters table.
• Grouping and ungrouping filters
• Moving filters up and down in the filters table

The Filter Table contains the following elements:

Boolean - Specifies Boolean values for the filter. Click the drop-down menu to display the available values. The only value displayed for the first filter is NOT. All subsequent filters display AND, OR, AND NOT, and OR.

Open Parenthesis - Adds an opening parenthesis to the filter.

Operand - Enters operands on both sides of the filter operator. Click the drop-down menu to display the available values Select Field displays the Select Field dialog, which enables you to select fields from the source and target tables for the query. CASE displays the Case tab , which you can use to create a case expression for the clause. Subquery adds a select * from statement to the operand, where you can develop a subquery that you can nest in the clause. Expression displays the Expression tab, which enables you to create complex filters. When appropriate, you can click Insert Values in the right-hand operand to see a list of available values. Note that you can use the Enclose values in parentheses option in the Select Values dialog to specify that the inserted values are enclosed in parentheses.

Operator - Adds an operator to the filter. Click the drop-down menu to select from the following values: =, <>, IN (,), NOT IN (,), >, >=, <, <=, BETWEEN, NOT BETWEEN, EXISTS, NOT EXISTS, IS NULL, NOT IS NULL, CONTAINS, NOT CONTAINS, LIKE (Matches pattern), and NOT LIKE (Does not match pattern).

Close Parenthesis - Adds a closing parenthesis to the filter.