The condition builder options allow you to create and use dynamically predefined values for the specified types of columns, fields, tables, or condition operators.
The main use case of this functionality is filtering by fields of Date/Time type. The options facilitate filtering by using predefined values, such as "Yesterday", "Week before", "Next Month" and others.
The following options are implemented for the Date, DateTime, DateTime Specific column types:
- Tomorrow
- Today
- Yesterday
These options are delivered within the platform.
Create an option
To create a new option, complete the steps below:
- Navigate to System Definition → Condition Builder → Options.
- Click New and fill in the fields.
- Click Save or Save and Exit to apply the changes.
Option form fields
| Field | Mandatory | Description |
|---|---|---|
| Title | Y | Specify the option name. It will be displayed in the condition builder values choice list.
|
| Active | Select this checkbox to make the option active. If not selected, this option is not displayed in the condition builder values choice list. | |
| Field type | N | Specify a column type to which this option is applicable. If not specified, then the option will be applicable to all field types created in the system. |
| Refer to table | N | Specify a referring table (this is helpful in case if you need to select all fields that refer to any specific field of some specific table). This field appears when the Field type field value is Reference or List. |
| Use for field | N | Specify a field to which this option is applicable. If not specified, then the option applies to all columns. |
| Use in tables | N | Specify tables to which this option is applicable. You can specify more than one table. If not specified, the option applies to the whole table structure. |
| Use with operators | N | Specify condition operators to which this option is applicable. You can specify more than one type. If not specified, the option applies to all operators supported. To find a list of operators supported by options, navigate here: System Definition → Condition Builder → Operators To add new operators to this list, contact the vendor. |
| Order | N | Specify an option order. If more than one similar option are created, they will be applied according to the specified value in the ascending order. |
| Script | N | Specify a script implementing the option logic. You can use Script Includes when defining option logic. To do this, complete the following steps:
dateWeekAfter function getDateWeekAfter() {
const simpleDateTime = new SimpleDateTime();
simpleDateTime.addDays(7);
return simpleDateTime.getDate();
}
Importing Script Include ss.importIncludeScript('getDateWeekAfter');
setResult(getDateWeekAfter());
|
Option example
For example, you need an option that allows you to quickly choose a specific user from the Employee table when selecting managers. To do this, create an option with the field values as described below:
| Field | Value |
|---|---|
| Title | John Doe |
| Active | Yes |
| Field type | Reference |
| Use for field | Manager |
| Use in table | Employee |
| Use with operators | IS |
As a result, you have got a new option for the Employee table, as shown on the screenshot below.
