Adding a conditional statement
The Assign Condition window is displayed when a field is added to the Query Builder Conditions tab.
To add a conditional statement:
- Access the Query Builder. See Accessing the Query Builder window
- Click the Conditions tab in the Query Builder window.
-
Select a table from the upper left side of the Query
Builder window.
Note: If required, click the plus sign to expand the list of tables.
-
Select a field from the upper right side of the Query
Builder window. This field displays all fields that belong to the
selected table. Double-click the field to add it to the grid at the bottom of
the window. The Assign Condition window displays
automatically.
Note: You can access this window at any time by double clicking a statement in the grid.
- Select an Operator field. See Query Builder statement operators.
-
Perform
these
tasks
in
the Value is
field:
- Specify a value or click Browse to select a
value.
If you selected in as an operator, the values must have quotation marks around each entry.
- If you selected a date/time field, string, or integer field type and require to use a custom parameter, select the Use Value as a Literalcheck box. Click the arrow in the Value is field, to select a condition parameter if one is available. See Using condition parameters
Note: If you select a parameter with an X placeholder value, the Provide Template Value window is displayed. In the field, specify the numeric value to replace the placeholder. - Specify a value or click Browse to select a
value.
-
Select the Case
Sensitive Comparecheck box, if you require the capitalization of
the value used as part of the condition. By default this option is selected.
Note: If you are using MS SQL Server, the Case Sensitive Compare check box is not applicable. All queries are case insensitive.
- Click OK.
- Repeat steps 1 to 8, and select the appropriate connector to add another condition statement. See Query Builder Statement Connectors