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:

Access the Query Builder. See Accessing the Query Builder
Select the Conditions tab.
Add a condition statement. See Query Builder Conditions tab
The Assign Condition window displays.
Select an Operator. See Calculated field operators
Perform one of these 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 Use Value as a Literal, click in the Value is field, and click the arrow to select a condition parameter if one is available.
  Note: If you selected a parameter with an "x" placeholder value, the Provide Template Valuewindow is displayed. In this window, specify the numeric value to replace the placeholder.
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.
Select Use Value as a Literal check box, if required. See Use Value as a Literal
Click OK.