Configuration Guide

10.3 HotFix 3

Back Next

Defining Comparison Conditions

You can define comparison conditions in a query. A comparison condition has a column, an SQL comparison operator, and another column or a constant. When you run the query, the query compares the values in the column against the condition, and returns records that satisfy the condition.

When the data in a column is encrypted, you cannot create conditions that use strings or wildcard characters.

In the properties pane, click the

Conditions

tab.

Click the

Add

icon.

The

Add Comparison

dialog box opens.

In the Column field, select the column on which you want to define a comparison.

In the Operator field, select an SQL comparison operator.

Select the target of the comparison, which can be another column or a constant.

If you select

Column

, select the column from the Edit Column list.

If you select

Constant

, the default value is NULL. To change the value, click the

Edit

icon, select a data type, and if the Value field appears, enter a value.

For example, the following image shows a comparison condition that compares values in the column LAST_NAME with the string %JO%:

The Add Comparison dialog box contains the following condition: the column is C_B_PARTY - LAST_NAME, the operator is an equal sign, the type is Constant, and the value is %JO%.

When you run the query, the query returns records with values like “Johnson”, “Vallejo”, and “Major”.

Click

The condition appears in the table.

Optionally, you can edit, reorder, or remove conditions.

Option	Description
Edit	Select the condition, and click the Edit icon.
Reorder	Select the condition, and click the Move Up or Move Down icon.
Remove	Select the condition, and click the Delete icon.