Page History

Condition The condition builder options allow creating you to create and use dynamically evaluated predefined values for the specified column types of columns, or fields, or tables, or condition operators.

The main use case of this functionality is filtering by fields of Date/Time /DateTime type. Options The options facilitate filtering by using predefined values, such as "Yesterday", "Week before", "Next Month" and others.

Tip

The following options are implemented for the Date, DateTime, DateTime Specific column types:

Tomorrow
Today
Yesterday

These options are delivered within the platform.

Creating a new

Create an option

To create a new option, please 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

then for option is is applicable for against this option is applicable for operators for then is applicable for please Definition → Builder → . please your there is then when For keep sequence below

Field

Mandatory

Description

Title

Y

The Specify the option name. It will be displayed in displayed in the condition builder values choice list. See the screenshot below as an example;

Image Modified

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 for to which this option is applicable. If not specified, then the option will be applicable for 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.

Tip
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.

Note
You can use Script Includes

when defining option logic.

To do this,

complete the

following steps:

Create a script include as described in the article mentioned above.
Import it using the ss.importIncludeScript(name) method.

Code Block

language	js
theme	Eclipse
title	dateWeekAfter
linenumbers	true

function getDateWeekAfter() {
const simpleDateTime = new SimpleDateTime();
simpleDateTime.addDays(7);
return simpleDateTime.getDate();
}

Code Block

language	js
theme	Eclipse
title	Importing Script Include
linenumbers	true

ss.importIncludeScript('getDateWeekAfter');
setResult(getDateWeekAfter());

This field appears when the Field type field value is Reference.

Refer to Table

N

This field allows specifying a referring table (this is helpful in case if you need to select all fields referring to any specified field of some specified table).

Option example

For example, we you need an option that allows rapid choosing of the specified you to quickly choose a specific user from the employees' list when performing selections of Employee table when selecting managers. For To do this, start creating create an option and fill in the fields as shown 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, we you have got a new option against for the Employee table, as shown on the screenshot below.

Table of Contents

absoluteUrl	true
class	fixedPosition
printable	false

Page tree

Versions Compared

Old Version 1

New Version 2

Key

Create an option

Option example