Operators

FlowLakes has two operator vocabularies. Condition operators decide whether an automation fires. Filter operators decide which records a query returns. They are separate sets with some overlapping names, so check the right table for the surface you are configuring.

Condition operators

Each family of automation evaluates its own vocabulary, and a blueprint or a rule is refused at build time when it names an operator its family does not have. The four tables below are read from the four evaluators.

Business rules

Source: rule_shape.RULE_OPERATORS.

Operator	Meaning
changed	Field changed in this update.
changed_from	Field changed away from the target value.
changed_to	Field changed to the target value.
contains	Field value contains the target as a substring.
equals	Field value equals the target.
greater_than	Field value is greater than the target.
greater_than_or_equal	Field value is greater than or equal to the target.
in	Field value is one of the listed values.
is_empty	Field has no value (null, empty, or falsy).
is_not_empty	Field has a value.
is_not_null	Field is not null; it may still be empty or falsy (business rules only).
is_null	Field is exactly null/missing, not merely empty or falsy (business rules only).
less_than	Field value is less than the target.
less_than_or_equal	Field value is less than or equal to the target.
not_equals	Field value differs from the target.
not_in	Field value is none of the listed values.
not_null	Alias of is_not_null (business rules only).
null	Alias of is_null (business rules only).

Workflow and agent triggers

Source: record_event_dispatcher.WORKFLOW_TRIGGER_OPERATORS.

Operator	Meaning
between	Field value falls within an inclusive range of two values.
changed	Field changed in this update.
changed_from	Field changed away from the target value.
changed_to	Field changed to the target value.
contains	Field value contains the target as a substring.
does_not_contain	Field value does not contain the target as a substring.
does_not_start_with	Field value does not start with the target.
ends_with	Field value ends with the target.
equals	Field value equals the target.
greater_than	Field value is greater than the target.
greater_than_or_equal	Field value is greater than or equal to the target.
in	Field value is one of the listed values.
is_empty	Field has no value (null, empty, or falsy).
is_not_empty	Field has a value.
less_than	Field value is less than the target.
less_than_or_equal	Field value is less than or equal to the target.
not_equals	Field value differs from the target.
not_in	Field value is none of the listed values.
starts_with	Field value starts with the target.

Approval policies

Source: approval_policy_service.APPROVAL_CONDITION_OPERATORS.

Operator	Meaning
contains	Field value contains the target as a substring.
equals	Field value equals the target.
greater_than	Field value is greater than the target.
in	Field value is one of the listed values.
is_empty	Field has no value (null, empty, or falsy).
is_not_empty	Field has a value.
less_than	Field value is less than the target.
not_equals	Field value differs from the target.
not_in	Field value is none of the listed values.

Notification rules

Source: notification.engine.NotificationEngine.CONDITION_OPERATORS.

Operator	Meaning
changed	Field changed in this update.
changed_from	Field changed away from the target value.
changed_from_to	Field changed from one specific value to another.
changed_to	Field changed to the target value.
contains	Field value contains the target as a substring.
ends_with	Field value ends with the target.
equals	Field value equals the target.
greater_than	Field value is greater than the target.
in	Field value is one of the listed values.
is_empty	Field has no value (null, empty, or falsy).
is_not_empty	Field has a value.
less_than	Field value is less than the target.
not_equals	Field value differs from the target.
not_in	Field value is none of the listed values.
starts_with	Field value starts with the target.

Unlisted operators mis-fire silently

An operator outside this set is rejected when a blueprint or rule is validated, because at runtime it fails quietly rather than raising. A business rule treats an unknown operator as always-true and fires on every record; a notification or workflow condition treats it as always-false and never fires. Use only the operators in the table above.

Filter operators

Record list views and report filters use these operators. Text comparisons (contains, startsWith, endsWith, doesNotContain) are case-insensitive.

Operator	Meaning
between	Column falls within an inclusive range of two values.
contains	Column text contains the value, case-insensitive.
doesNotContain	Column text does not contain the value, case-insensitive.
endsWith	Column text ends with the value, case-insensitive.
equals	Column equals the value.
greaterThan	Column is greater than the value.
greaterThanOrEqual	Column is greater than or equal to the value.
in	Column matches one of a list of values.
isEmpty	Column is null, or empty for text columns.
isNotEmpty	Column has a non-empty value.
isNotNull	Column is not null.
isNull	Column is null.
lessThan	Column is less than the value.
lessThanOrEqual	Column is less than or equal to the value.
notEquals	Column differs from the value.
notIn	Column matches none of a list of values.
startsWith	Column text starts with the value, case-insensitive.

Filter operator aliases

These spellings are accepted and normalized to the canonical operator above, so a saved filter written either way behaves the same.

Alias	Canonical operator
!=	notEquals
<	lessThan
<=	lessThanOrEqual
<>	notEquals
=	equals
==	equals
>	greaterThan
>=	greaterThanOrEqual
eq	equals
gt	greaterThan
gte	greaterThanOrEqual
lt	lessThan
lte	lessThanOrEqual
ne	notEquals
neq	notEquals
notContains	doesNotContain

Related

• Business rules and workflows evaluate condition operators.
• Tables and records list views and reports evaluate filter operators.