1C:Enterprise | 1C:Enterprise Developer's Community

Bilingual presentation of data composition system keywords

One of the features of 1C:Enterprise data composition system expressions is that all the keywords can be written in two ways, just like in 1C:Enterprise script: in English and in Russian.

The table below provides the mapping of English and Russian keywords used in data composition system expressions.

English

Russian

AND

Ð˜

ARRAY

ÐœÐÐ¡Ð¡Ð˜Ð'

AVERAGE

Ð¡Ð Ð•Ð”ÐÐ•Ð•

BEGINOFPERIOD

ÐÐÐ§ÐÐ›ÐžÐŸÐ•Ð Ð˜ÐžÐ”Ð

CAST

Ð'Ð«Ð ÐÐ—Ð˜Ð¢Ð¬

CHARACTERISTICTYPES

Ð'Ð˜Ð”Ð«Ð¥ÐÐ ÐÐšÐ¢Ð•Ð Ð˜Ð¡Ð¢Ð˜Ðš

CHARACTERISTICVALUES

Ð—ÐÐÐ§Ð•ÐÐ˜Ð¯Ð¥ÐÐ ÐÐšÐ¢Ð•Ð Ð˜Ð¡Ð¢Ð˜Ðš

CHOICE

Ð'Ð«Ð‘Ð ÐÐ¢Ð¬

DATEADD

Ð”ÐžÐ‘ÐÐ'Ð˜Ð¢Ð¬ÐšÐ”ÐÐ¢Ð•

DATEDIFFERENCE

Ð ÐÐ—ÐÐžÐ¡Ð¢Ð¬Ð”ÐÐ¢

DATETIME

Ð”ÐÐ¢ÐÐ'Ð Ð•ÐœÐ¯

DAY

Ð”Ð•ÐÐ¬

DAYOFYEAR

Ð”Ð•ÐÐ¬Ð“ÐžÐ”Ð

DISTINCT

Ð ÐÐ—Ð›Ð˜Ð§ÐÐ«Ð•

ENDOFPERIOD

ÐšÐžÐÐ•Ð¦ÐŸÐ•Ð Ð˜ÐžÐ”Ð

ESCAPE

Ð¡ÐŸÐ•Ð¦Ð¡Ð˜ÐœÐ'ÐžÐ›

EVALEXPRESSION

Ð'Ð«Ð§Ð˜Ð¡Ð›Ð˜Ð¢Ð¬Ð'Ð«Ð ÐÐ–Ð•ÐÐ˜Ð•

EVALEXPRESSIONWITHGROUPARRAY

Ð'Ð«Ð§Ð˜Ð¡Ð›Ð˜Ð¢Ð¬Ð'Ð«Ð ÐÐ–Ð•ÐÐ˜Ð•Ð¡Ð“Ð Ð£ÐŸÐŸÐ˜Ð ÐžÐ'ÐšÐžÐ™ÐœÐÐ¡Ð¡Ð˜Ð'

EVALEXPRESSIONWITHGROUPVALUETABLE

Ð'Ð«Ð§Ð˜Ð¡Ð›Ð˜Ð¢Ð¬Ð'Ð«Ð ÐÐ–Ð•ÐÐ˜Ð•Ð¡Ð“Ð Ð£ÐŸÐŸÐ˜Ð ÐžÐ'ÐšÐžÐ™Ð¢ÐÐ‘Ð›Ð˜Ð¦ÐÐ—ÐÐÐ§Ð•ÐÐ˜Ð™

EVALUATE

Ð'Ð«Ð§Ð˜Ð¡Ð›Ð˜Ð¢Ð¬

FALSE

Ð›ÐžÐ–Ð¬

FORMAT

Ð¤ÐžÐ ÐœÐÐ¢

GROUPBY

Ð¡Ð'Ð•Ð ÐÐ£Ð¢Ð¬

GROUPPROCESSING

Ð“Ð Ð£ÐŸÐŸÐžÐ'ÐÐ¯ÐžÐ‘Ð ÐÐ‘ÐžÐ¢ÐšÐ

HOUR

Ð§ÐÐ¡

IN

Ð'

ISNULL

Ð•Ð¡Ð¢Ð¬NULL

JOINSTRINGS

Ð¡ÐžÐ•Ð”Ð˜ÐÐ˜Ð¢Ð¬Ð¡Ð¢Ð ÐžÐšÐ˜

KEYFIELD

ÐŸÐžÐ›Ð•ÐšÐ›Ð®Ð§Ð

LEVEL

Ð£Ð ÐžÐ'Ð•ÐÐ¬

LEVELINGROUP

Ð£Ð ÐžÐ'Ð•ÐÐ¬Ð'Ð“Ð Ð£ÐŸÐŸÐ˜Ð ÐžÐ'ÐšÐ•

LIKE

ÐŸÐžÐ”ÐžÐ‘ÐÐž

MAXIMUM

ÐœÐÐšÐ¡Ð˜ÐœÐ£Ðœ

MINIMUM

ÐœÐ˜ÐÐ˜ÐœÐ£Ðœ

MINUTE

ÐœÐ˜ÐÐ£Ð¢Ð

MONTH

ÐœÐ•Ð¡Ð¯Ð¦

NAMEFIELD

ÐŸÐžÐ›Ð•Ð˜ÐœÐ•ÐÐ˜

NOT

ÐÐ•

OBJECTFIELD

ÐŸÐžÐ›Ð•ÐžÐ‘ÐªÐ•ÐšÐ¢Ð

OR

Ð˜Ð›Ð˜

ORDER

Ð£ÐŸÐžÐ Ð¯Ð”ÐžÐ§Ð˜Ð¢Ð¬

PRESENTATION

ÐŸÐ Ð•Ð”Ð¡Ð¢ÐÐ'Ð›Ð•ÐÐ˜Ð•

QUANTITY

ÐšÐžÐ›Ð˜Ð§Ð•Ð¡Ð¢Ð'Ðž

QUARTER

ÐšÐ'ÐÐ Ð¢ÐÐ›

SECOND

Ð¡Ð•ÐšÐ£ÐÐ”Ð

SEQUENCENUMBER

ÐÐžÐœÐ•Ð ÐŸÐžÐŸÐžÐ Ð¯Ð”ÐšÐ£

SEQUENCENUMBERINGROUPING

ÐÐžÐœÐ•Ð ÐŸÐžÐŸÐžÐ Ð¯Ð”ÐšÐ£Ð'Ð“Ð Ð£ÐŸÐŸÐ˜Ð ÐžÐ'ÐšÐ•

STRING

Ð¡Ð¢Ð ÐžÐšÐ

STRINGLENGTH

Ð”Ð›Ð˜ÐÐÐ¡Ð¢Ð ÐžÐšÐ˜

SUBSTRING

ÐŸÐžÐ”Ð¡Ð¢Ð ÐžÐšÐ

SUM

Ð¡Ð£ÐœÐœÐ

TRUE

Ð˜Ð¡Ð¢Ð˜ÐÐ

TYPE

Ð¢Ð˜ÐŸ

TYPEFIELD

ÐŸÐžÐ›Ð•Ð'Ð˜Ð”Ð

VALUEFIELD

ÐŸÐžÐ›Ð•Ð—ÐÐÐ§Ð•ÐÐ˜Ð¯

VALUEISFILLED

Ð—ÐÐÐ§Ð•ÐÐ˜Ð•Ð—ÐÐŸÐžÐ›ÐÐ•ÐÐž

VALUETABLE

Ð¢ÐÐ‘Ð›Ð˜Ð¦ÐÐ—ÐÐÐ§Ð•ÐÐ˜Ð™

VALUETYPEFIELD

ÐŸÐžÐ›Ð•Ð¢Ð˜ÐŸÐÐ—ÐÐÐ§Ð•ÐÐ˜Ð¯

WEEK

ÐÐ•Ð”Ð•Ð›Ð¯

WEEKDAY

Ð”Ð•ÐÐ¬ÐÐ•Ð”Ð•Ð›Ð˜

YEAR

Ð“ÐžÐ”

See also: Data composition system expression language

English	Russian
AND	Ð˜
ARRAY	ÐœÐÐ¡Ð¡Ð˜Ð'
AVERAGE	Ð¡Ð Ð•Ð”ÐÐ•Ð•
BEGINOFPERIOD	ÐÐÐ§ÐÐ›ÐžÐŸÐ•Ð Ð˜ÐžÐ”Ð
CAST	Ð'Ð«Ð ÐÐ—Ð˜Ð¢Ð¬
CHARACTERISTICTYPES	Ð'Ð˜Ð”Ð«Ð¥ÐÐ ÐÐšÐ¢Ð•Ð Ð˜Ð¡Ð¢Ð˜Ðš
CHARACTERISTICVALUES	Ð—ÐÐÐ§Ð•ÐÐ˜Ð¯Ð¥ÐÐ ÐÐšÐ¢Ð•Ð Ð˜Ð¡Ð¢Ð˜Ðš
CHOICE	Ð'Ð«Ð‘Ð ÐÐ¢Ð¬
DATEADD	Ð”ÐžÐ‘ÐÐ'Ð˜Ð¢Ð¬ÐšÐ”ÐÐ¢Ð•
DATEDIFFERENCE	Ð ÐÐ—ÐÐžÐ¡Ð¢Ð¬Ð”ÐÐ¢
DATETIME	Ð”ÐÐ¢ÐÐ'Ð Ð•ÐœÐ¯
DAY	Ð”Ð•ÐÐ¬
DAYOFYEAR	Ð”Ð•ÐÐ¬Ð“ÐžÐ”Ð
DISTINCT	Ð ÐÐ—Ð›Ð˜Ð§ÐÐ«Ð•
ENDOFPERIOD	ÐšÐžÐÐ•Ð¦ÐŸÐ•Ð Ð˜ÐžÐ”Ð
ESCAPE	Ð¡ÐŸÐ•Ð¦Ð¡Ð˜ÐœÐ'ÐžÐ›
EVALEXPRESSION	Ð'Ð«Ð§Ð˜Ð¡Ð›Ð˜Ð¢Ð¬Ð'Ð«Ð ÐÐ–Ð•ÐÐ˜Ð•
EVALEXPRESSIONWITHGROUPARRAY	Ð'Ð«Ð§Ð˜Ð¡Ð›Ð˜Ð¢Ð¬Ð'Ð«Ð ÐÐ–Ð•ÐÐ˜Ð•Ð¡Ð“Ð Ð£ÐŸÐŸÐ˜Ð ÐžÐ'ÐšÐžÐ™ÐœÐÐ¡Ð¡Ð˜Ð'
EVALEXPRESSIONWITHGROUPVALUETABLE	Ð'Ð«Ð§Ð˜Ð¡Ð›Ð˜Ð¢Ð¬Ð'Ð«Ð ÐÐ–Ð•ÐÐ˜Ð•Ð¡Ð“Ð Ð£ÐŸÐŸÐ˜Ð ÐžÐ'ÐšÐžÐ™Ð¢ÐÐ‘Ð›Ð˜Ð¦ÐÐ—ÐÐÐ§Ð•ÐÐ˜Ð™
EVALUATE	Ð'Ð«Ð§Ð˜Ð¡Ð›Ð˜Ð¢Ð¬
FALSE	Ð›ÐžÐ–Ð¬
FORMAT	Ð¤ÐžÐ ÐœÐÐ¢
GROUPBY	Ð¡Ð'Ð•Ð ÐÐ£Ð¢Ð¬
GROUPPROCESSING	Ð“Ð Ð£ÐŸÐŸÐžÐ'ÐÐ¯ÐžÐ‘Ð ÐÐ‘ÐžÐ¢ÐšÐ
HOUR	Ð§ÐÐ¡
IN	Ð'
ISNULL	Ð•Ð¡Ð¢Ð¬NULL
JOINSTRINGS	Ð¡ÐžÐ•Ð”Ð˜ÐÐ˜Ð¢Ð¬Ð¡Ð¢Ð ÐžÐšÐ˜
KEYFIELD	ÐŸÐžÐ›Ð•ÐšÐ›Ð®Ð§Ð
LEVEL	Ð£Ð ÐžÐ'Ð•ÐÐ¬
LEVELINGROUP	Ð£Ð ÐžÐ'Ð•ÐÐ¬Ð'Ð“Ð Ð£ÐŸÐŸÐ˜Ð ÐžÐ'ÐšÐ•
LIKE	ÐŸÐžÐ”ÐžÐ‘ÐÐž
MAXIMUM	ÐœÐÐšÐ¡Ð˜ÐœÐ£Ðœ
MINIMUM	ÐœÐ˜ÐÐ˜ÐœÐ£Ðœ
MINUTE	ÐœÐ˜ÐÐ£Ð¢Ð
MONTH	ÐœÐ•Ð¡Ð¯Ð¦
NAMEFIELD	ÐŸÐžÐ›Ð•Ð˜ÐœÐ•ÐÐ˜
NOT	ÐÐ•
OBJECTFIELD	ÐŸÐžÐ›Ð•ÐžÐ‘ÐªÐ•ÐšÐ¢Ð
OR	Ð˜Ð›Ð˜
ORDER	Ð£ÐŸÐžÐ Ð¯Ð”ÐžÐ§Ð˜Ð¢Ð¬
PRESENTATION	ÐŸÐ Ð•Ð”Ð¡Ð¢ÐÐ'Ð›Ð•ÐÐ˜Ð•
QUANTITY	ÐšÐžÐ›Ð˜Ð§Ð•Ð¡Ð¢Ð'Ðž
QUARTER	ÐšÐ'ÐÐ Ð¢ÐÐ›
SECOND	Ð¡Ð•ÐšÐ£ÐÐ”Ð
SEQUENCENUMBER	ÐÐžÐœÐ•Ð ÐŸÐžÐŸÐžÐ Ð¯Ð”ÐšÐ£
SEQUENCENUMBERINGROUPING	ÐÐžÐœÐ•Ð ÐŸÐžÐŸÐžÐ Ð¯Ð”ÐšÐ£Ð'Ð“Ð Ð£ÐŸÐŸÐ˜Ð ÐžÐ'ÐšÐ•
STRING	Ð¡Ð¢Ð ÐžÐšÐ
STRINGLENGTH	Ð”Ð›Ð˜ÐÐÐ¡Ð¢Ð ÐžÐšÐ˜
SUBSTRING	ÐŸÐžÐ”Ð¡Ð¢Ð ÐžÐšÐ
SUM	Ð¡Ð£ÐœÐœÐ
TRUE	Ð˜Ð¡Ð¢Ð˜ÐÐ
TYPE	Ð¢Ð˜ÐŸ
TYPEFIELD	ÐŸÐžÐ›Ð•Ð'Ð˜Ð”Ð
VALUEFIELD	ÐŸÐžÐ›Ð•Ð—ÐÐÐ§Ð•ÐÐ˜Ð¯
VALUEISFILLED	Ð—ÐÐÐ§Ð•ÐÐ˜Ð•Ð—ÐÐŸÐžÐ›ÐÐ•ÐÐž
VALUETABLE	Ð¢ÐÐ‘Ð›Ð˜Ð¦ÐÐ—ÐÐÐ§Ð•ÐÐ˜Ð™
VALUETYPEFIELD	ÐŸÐžÐ›Ð•Ð¢Ð˜ÐŸÐÐ—ÐÐÐ§Ð•ÐÐ˜Ð¯
WEEK	ÐÐ•Ð”Ð•Ð›Ð¯
WEEKDAY	Ð”Ð•ÐÐ¬ÐÐ•Ð”Ð•Ð›Ð˜
YEAR	Ð“ÐžÐ”