Define a Comparison Clause

A Comparison Clause is a Query Clause that finds all records containing a field with a particular value.

Use the Query Builder window to create a Comparison Clause.

When you define this type of clause, you define:

• Field: Field for which you want to find a value.
• Operator: Word or phrase (equals, greater than, contains) that provides the necessary information for two values to produce an output.
• Value: Value for which the clause searches.

Good to know:

• Expressions, Stored Values and system functions appear as folders after the Fields if they are available.
• Some operators are only shown for particular data types (example: "Like" is only available for text Fields).
• If the Field is validated, the Legal Values Button displays on the right of the drop-down. It allows you to select from a list of appropriate values.
• If Globalization is enabled for your system, you may be able to choose Lookup Object values from different cultures. For more information, see Using Translated Lookup Table Values in Search Queries.

To create a Comparison Clause:

1. Open a Query Builder.
2. Click the New button , and then select Comparison Clause.

   The Comparison Clause section opens.

3. Select the Field for which you want to find a value (example: Call Source):
   1. Click the Down arrow next to the left-most drop-down to reveal the list of applicable Fields.
   2. Select a Field from the list.

      The value drop-down (right-most drop-down) automatically populates.

4. Click the Operator drop-down to reveal applicable operators, and then select an operator.
5. Provide a value or click the Down arrow next to the right-most drop-down to reveal applicable options and Tokens, including:
   • Fields
   • System Functions
   • Prompts
   • Expressions
   • Stored Values
   • Metric Values
6. Select a value from the list (this is the value the search will look for).

   The Comparison Clause displays in the Query.

7. Add additional clauses to refine your search (optional).
   Note: If you are using the Stored Query Builder, use the Options button to define additional options, including availability and icon image.

8. Click OK.