...
Attribute | Description | ||
|---|---|---|---|
Field | This option allows you to select a field from a model based on the chosen object, helping you to define criteria using model fields. | ||
Operators | The available operators will depend on the type of field selected, allowing you to set the criteria accordingly.
| ||
Source Type | You can choose from several options to compare values with the selected field. The available options include:
|
Filters Attributes:
...
Filter Operators
Operator | Supported Field Types | Description |
|---|---|---|
Equal | Number, Currency, Date, Text, Boolean, Picklist | The equal operator is used to compare two values or expressions. It is used to compare numbers, strings, Boolean values, variables, objects, etc. The result is TRUE if the expressions are equal otherwise it’s FALSE |
Contains | Text, Picklist | The contains operator returns TRUE if the value on the left contains the value on the right, and otherwise FALSE |
Starts With | Text, Picklist | It returns TRUE if a string or number starts with the specified character otherwise it returns FALSE. |
Ends With | Text, Picklist | It returns TRUE if a string or number ends with the specified character otherwise it returns FALSE |
In | Text, Picklist | IN operator allows you to easily test if the expression matches any value in the list of values. Determines whether the value of an expression is equal to any of several values in a specified list. |
Source types
Source Type | Description | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
Static | Use this option to provide a fixed static value. | |||||||||||
Model | Choose the field from other models whose value you want to compare. | |||||||||||
Variable | Select from the variables created in the layout whose value you want to compare. | |||||||||||
User | You can also select fields from the current logged-in user in your organization to compare with model field
| |||||||||||
Null | The Null option will check if the selected model field has no value at all, meaning the field is completely empty and hasn't been populated with any data. | |||||||||||
Blank | The Blank option will check if the selected model field has been populated with a blank or empty value, such as an empty string.
|