ENUM
FieldOperator
Comparison applied between a field and the supplied values in a filter condition or formatting rule.
link GraphQL Schema definition
- enum FieldOperator {
- # For checkbox fields only: matches records where the checkbox is checked (or
- # unchecked when the value is false).
- # Field equals the value; text comparison ignores case.
- # Field does not equal the value, including records where the field is empty.
- # Field has no value; no comparison value is needed.
- # Field has a value; no comparison value is needed.
- # Field is less than the value.
- # Field is less than or equal to the value.
- # Field is greater than the value.
- # Field is greater than or equal to the value.
- # Field lies between the two values, bounds included; an omitted bound leaves that
- # side open.
- # Field lies outside the two values or is empty.
- # Field contains the value as a substring, ignoring case.
- # Field does not contain the value as a substring, or is empty.
- # Multi-value field contains all of the listed values.
- # Multi-value field does not contain all of the listed values, or is empty.
- # Date field falls within a dynamic period given by a PeriodKind value (for
- # example MonthCurrent), evaluated relative to today.
- # Date field falls outside the given dynamic period.
- # Field matches at least one of the listed values.
- # Field matches none of the listed values, or is empty.
- # Text field starts with the value, ignoring case.
- # Text field ends with the value, ignoring case.
- # For owner fields: the owner is an active user.
- # For owner fields: the owner is a deactivated user.
- }
link Require by
- ColumnFormattingFieldFilterRuleConditional formatting rule: a condition on a field value and the color applied to the matching cells.
- ColumnFormattingFilterFieldRuleInterfaceCondition of a conditional formatting rule, evaluated against a field value.
- DashboardTileConditionalFormattingRule that colors a dashboard tile when its value meets a condition.
- EntityHealthFieldFilterRuleRule of a health indicator: a condition on a field and the score a record gets when it matches.
- FieldFilterRuleFilter condition that compares one field with a set of values.
- FieldFilterRuleParamsFilter condition that compares one field with a set of values.
- FilterFieldRuleInterfaceSingle filter condition: the field, the comparison operator and the values it is compared with.