Assigning Query Conditions

When you add a field to the Query Builder Conditions tab, the Assign Condition window is displayed for that field.

To assign:

  1. Open Query Builder.
  2. Select the Conditions tab.
  3. Add a condition statement.
    The Assign Condition window displays.
  4. Select an Operator.
  5. In the Value Is field, do one of the following:
    • 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 want to use a custom parameter, select Use Value as a Literal, click in the Value is box, and then click the drop-down arrow to select a condition parameter if one is available. See Using Condition Parameters
      Note: If you selected a parameter with an "x" placeholder value, the Provide Template Value dialog box opens. In the box, type the numeric value to replace the placeholder.
  6. Select the Case Sensitive Compare check box to use capitalization as part of the condition.

    If you are using Microsoft SQL Server, the Case Sensitive Compare option is not applicable. All queries are case insensitive.

  7. If required, select Use Value as a Literal check box.
  8. Click OK.
Related topics