Skip to main content
Version: 1.21.3

Condition Builder Options

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.

In the URL, options are displayed as opt:{option_id}.

Create an option

To create a new option, complete the steps below:

  1. Navigate to System SettingsCondition BuilderOptions.
  2. Click New and fill in the fields.
  3. Click Save or Save and exit to apply the changes.

Option form fields

FieldMandatoryDescription
TitleY

Specify the option name.

It will be displayed in the condition builder values choice list.

Field TypeNSpecify 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 TableN

Specify the table that the selected field in the condition builder will refer to.

This field appears when the Field type is Reference or List.

Use for FieldNSpecify a field to which this option is applicable. If not specified, then the option applies to all columns.
Use in TablesNSpecify tables to which this option is applicable. You can specify more than one table. If not specified, the option applies to all tables.
Use with OperatorsN

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 to System SettingsCondition BuilderOperators.

To add new operators to this list, contact the vendor.

ScriptN

Specify a script implementing the option logic.

ActiveNSelect this checkbox to make the option active. If not selected, this option is not displayed in the condition builder values choice list.
OrderNSpecify an option order. If multiple similar options are created, they will be applied according to the specified value in ascending order.
caution

You can use Script Includes when defining option logic. To do so, complete the following steps:

  1. Create a script include.
dateWeekAfter
function getDateWeekAfter() {
const simpleDateTime = new SimpleDateTime();
simpleDateTime.addDays(7);
return simpleDateTime.getDate();
}
  1. Import it using the ss.importIncludeScript(name) method.
Importing Script Include
ss.importIncludeScript('getDateWeekAfter');
setResult(getDateWeekAfter());