This field type is used to build AND/OR filters. It may be used as an additional field to set a condition, for example, for a business rule.
See the Condition Builder and Interface articles to learn more.
| Description | In SimpleOne interface, it is displayed as a widget for filter configuration, the Condition Builder. It stores JSON conditions.
|
|---|---|
| Scalar Type | text |
| Validation Criteria | The validation criteria are:
|
Creating a column
Role required: admin.
To create a column of condition type, complete the following steps:
- Navigate to the System Settings → All Tables.
- Open the table for which you want to create a column.
- Scroll down to the Related Lists area and click on the Columns tab.
- Click New and fill in the fields.
- Click Save or Save and Exit to apply changes.
Tabs specific for the condition type columns
| Type Specification tab | |||
| Field | Mandatory | Description | |
|---|---|---|---|
| Dependent on Column | Y | A reference to the Tables dictionary. Specify a table that will share the fields with the newly created column. | |
| Extra Attributes | N | You can specify the extended operators like this:
These operators become available to use in the column. | |
