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:

  1. Access the Query Builder. See Accessing the Query Builder window
  2. Click the Conditions tab in the Query Builder window.
  3. 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.
  4. 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.
  5. Select an Operator field. See Query Builder statement operators.
  6. 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.
  7. 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.
  8. Click OK.
  9. Repeat steps 1 to 8, and select the appropriate connector to add another condition statement. See Query Builder Statement Connectors