Comparison Operators
Operators for comparing values.
Is Equal To
Returns true if both values are equal.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | First Value | integer, decimal, float, money, string, boolean, dateTime, date | First value |
| 1 | Second Value | integer, decimal, float, money, string, boolean, dateTime, date | Second value |
Notes:
- String comparisons are case-sensitive
- Numeric types are compared by value
Example:
Is Equal To(Status, "Active") → true if Status is "Active"
Is Equal To(Amount, 100) → true if Amount is 100
Is Not Equal To
Returns true if values are different.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Example:
Is Not Equal To(Status, "Closed") → true if Status is not "Closed"
Is Greater Than
Returns true if first value is strictly greater than second.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | First number | integer, decimal, float, money | Number to compare |
| 1 | Second number | integer, decimal, float, money | Number to compare against |
Example:
Is Greater Than(Amount, 1000) → true if Amount > 1000
Is Greater Than Or Equal To
Returns true if first value is greater than or equal to second.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Example:
Is Greater Than Or Equal To(Score, 70) → true if Score >= 70 (passing grade)
Is Less Than
Returns true if first value is strictly less than second.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Example:
Is Less Than(Stock, ReorderPoint) → true if below reorder point
Is Less Than Or Equal To
Returns true if first value is less than or equal to second.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Example:
Is Less Than Or Equal To(Age, 17) → true if Age is 17 or less (minor)
Contains
Returns true if a string contains the specified substring.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Base String | string | String to search in |
| 1 | Substring | string | String to search for |
Notes: Case-sensitive comparison.
Example:
Contains("Hello World", "World") → true
Contains(Email, "@company.com") → true if company email
Does Not Contain
Returns true if a string does NOT contain the substring.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Example:
Does Not Contain(Description, "confidential") → true if safe to share
Starts With
Returns true if text starts with specified characters.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Text | string | String to check |
| 1 | Beginning | string | Expected prefix |
Example:
Starts With(PhoneNumber, "+1") → true if US number
Starts With(OrderNumber, "ORD-") → true if valid order format
Does Not Start With
Returns true if text does NOT start with specified characters.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Ends With
Returns true if text ends with specified characters.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | Text | string | String to check |
| 1 | Ending | string | Expected suffix |
Example:
Ends With(Email, "@gmail.com") → true if Gmail address
Ends With(FileName, ".pdf") → true if PDF file
Does Not End With
Returns true if text does NOT end with specified characters.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Contains Item
Returns true if a list contains the specified item.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Arguments:
| # | Name | Type | Description |
|---|---|---|---|
| 0 | List | list | Collection to search |
| 1 | Item | integer, decimal, float, money, string, boolean, dateTime, date | Item to find |
Example:
Contains Item(ApprovedStatuses, CurrentStatus) → true if status is in approved list
Does Not Contain Item
Returns true if a list does NOT contain the specified item.
| Property | Value |
|---|---|
| Category | Boolean/Binary Logical |
| Min Arguments | 2 |
| Max Arguments | 2 |
| Returns | boolean |
Comparison Quick Reference
| Operator | Symbol | Description |
|---|---|---|
| Is Equal To | = | Values are exactly equal |
| Is Not Equal To | ≠ | Values are different |
| Is Greater Than | > | First is larger |
| Is Greater Than Or Equal To | >= | First is larger or equal |
| Is Less Than | < | First is smaller |
| Is Less Than Or Equal To | <= | First is smaller or equal |
| Contains | ⊃ | String includes substring |
| Starts With | ^ | String begins with prefix |
| Ends With | $ | String ends with suffix |
| Contains Item | ∈ | List includes value |