Appendix 1. Data composition system expression language

The data composition system expression language is intended for recording expressions used in several 1C:Enterprise system features. In particular, it is used in the data composition system for describing custom field expressions.

Literals

String

Number

Date

Boolean

Value

Fields

Parameters

Operations with numbers

Unary +

Binary +

Multiplication

Division

Remainder

Operations with strings

Concatenation (Binary +)

LIKE

Comparison operations

EQUAL

NOT EQUAL

LESS THAN

MORE THAN

LESS OR EQUAL

GREATER OR EQUAL

IN (for values)

IN (for data sets)

IS NULL

IS NOT NULL

Logical operations

NOT

AND

OR

Aggregate functions

SUM

COUNT

COUNT (DISTINCT)

MAX

MIN

AVG

ARRAY

VALUETABLE

GROUPPROCESSING

GROUPBY

GETPART

ORDER

JOINSTRINGS

Every

Any

Stddev_Pop

Stddev_Samp

Var_Samp

Var_Pop

Covar_Pop

Covar_Samp

Corr

Regr_Slope

Regr_Intercept

Regr_Count

Regr_R2

Regr_AvgX

Regr_AvgY

Regr_SXX

Regr_SYY

Regr_SXY

Rank

ClassificationABC

Other operations

CASE operation

Rules for comparing two values

Operations with NULL value

Operation priorities

Functions

EVAL

EVALEXPRESSION

Parameter usage example