Comparing field values

Field comparison allows users to evaluate equality between fields on the same table or on related tables by using operators in the condition builder.

Also, you can compare date type fields to determine whether the values are within a certain range of each other. For example, you can compare the planned start date of a task to the actual start date. You can use field comparisons in a list view and to generate reports.

The primary function of field comparison is evaluating whether two fields on a record or related record have identical values. For example, you can create a filter to display all incidents whose Caller field references the same user record as the Closed by field.

Available operators

Field comparison provides several filter operators for comparing field values.
  • [is same] if two field values are the same, evaluates to true.
  • [is different] if two field values are not the same, evaluates to true.
  • [is less than] if two date values are within a user-defined range of each other, evaluates to true.
  • [is more than] if two date values are not within a user-defined range of each other, evaluates to true.

Comparing choice list values

Field comparison compares the dictionary Value field of a choice list, not the Label value. For example, a high priority incident has a priority value of 1, not 1 - High. To find the Value of a choice, right-click the field label and select Configure Dictionary. The Choices related list shows the Value for each choice.

Comparing empty fields

By default, most filter operations do not return empty fields in their result set. To include records with empty fields in a result set, add a filter condition for the left operand with an operator of [is empty]. For more information, see Filtering on empty fields.