Data Composition System Expression Language
The data composition system expression language is intended to create expressions used throughout the system.
Expressions are used in the following subsystems:
- data composition schema – to describe calculated fields, total fields, link expressions, etc;
- data composition settings – to describe custom field expressions;
- data composition template – to describe data set link expressions, template parameter descriptions, etc.
Literal Constants
An expression can contain literal constants. Literal constants can be as follows:
- String;
- Number;
- Date;
- Boolean;
- Type.
String
String literal is enclosed in double quotation marks ("), e.g.:
"String literal"
If you need to use double quotation marks within a string literal, use two double quotation marks.
Example:
"Literal""in quotation marks"""
Number
A number is written without spaces, in decimal format. Its fractional part is separated by a period ("."). Example:
10.5
200
Date
A date literal is written using the DATETIME key literal. This keyword is followed by a year, month, day, hours, minutes, and seconds separated by commas. Specifying time is not mandatory.
Example:
DATETIME(1975, 1, 06) – January the sixth, 1975
DATETIME(2006, 12, 2, 23, 56, 57) – The Second of December, 2006, 23 h 56 m 57 s
Boolean
Boolean values can be written using True and False literals.
Type
A literal follows the Type keyword after which the name of type is written in brackets.
Example:
Type("String")
Value
To specify literals of other types (system enumerations, preset data), use the Value keyword followed by the literal name in brackets.
Value(AccountType. Active)
See also:
Operations with Numbers
Operations with Rows
Comparison Operations
Logical Operations
Aggregate Functions
Other Operations
Rules for Comparing Two Values
Working with NULL Value
Operation Priorities
Functions
Mechanism of Properties (Characteristics) and Categories
Bilingual Presentation of Data Composition System Keywords