When comparing fields, the two fields being compared are called the left operand and
The type of field selected in the left operand, and the operator selected, determine which
right operands are available. When using the [is same] or
[is different] operators, the right operand choices include only
fields of the same field type, such as String or
Integer, as the left operand.
For example, a filter on the Task [task] table with a left operand of [Opened
by] and an operator of [is same], only allows you to
choose user reference fields, such as the [Closed by] field, in the
The [is more than] and [is less than] operators
are only available with date type fields.
This example filter returns records where the user who opened the record also closed the