Field comparison allows users to evaluate equality between fields on the same table or
on related tables by using operators in the condition builder.
Additionally, you can compare date type fields to determine if 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
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.
Field comparison provides several filter operators for comparing field values.
- [is same] evaluates to true if two field values are the
- [is different] evaluates to true if two field values are not
- [is less than] evaluates to true if two date values are within
a user-defined range of each other.
- [is more than] evaluates to true if two date values are not
within a user-defined range of each other.
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.