Comparing Field Values

Filter criteria to compare field values.

You can compare the values of different fields within one info area provided these fields have the same data type. For further details, see Data Types in Aurea CRM.

To compare the values of different fields, do the following:
  1. Select a field from the drop-down list.
  2. Click (Add Field).
  3. Select the second field.
  4. Click (Add).
  5. Select the desired operator.

The following comparisons are possible:

  • date fields with date fields
  • time fields with time fields
  • rep fields with rep fields
  • numerical fields with numerical fields
  • text fields with text fields
  • logical fields with logical fields
  • catalog fields only if two or more fields are associated with the same catalog
Note: CRM.Designer does not perform any checks whether the compared fields are of the same type.