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

Bilingual presentation of query keywords

One of the features of 1C: Enterprise query language 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 query language keywords.

English

Russian

ALL

Ð'Ð¡Ð•

ALLOWED

Ð ÐÐ—Ð Ð•Ð¨Ð•ÐÐÐ«Ð•

AND

Ð˜

AS

ÐšÐÐš

ASC

Ð'ÐžÐ—Ð

AUTOORDER

ÐÐ'Ð¢ÐžÐ£ÐŸÐžÐ Ð¯Ð”ÐžÐ§Ð˜Ð'ÐÐÐ˜Ð•

AVG

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

BEGINOFPERIOD

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

BETWEEN

ÐœÐ•Ð–Ð”Ð£

BOOLEAN

Ð‘Ð£Ð›Ð•Ð'Ðž

CASE

Ð'Ð«Ð‘ÐžÐ

CAST

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

COUNT

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

DATE

Ð”ÐÐ¢Ð

DATEADD

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

DATEDIFF

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

DATETIME

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

DAY

Ð”Ð•ÐÐ¬

DAYOFYEAR

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

DESC

Ð£Ð‘Ð«Ð'

DISTINCT

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

DROP

Ð£ÐÐ˜Ð§Ð¢ÐžÐ–Ð˜Ð¢Ð¬

ELSE

Ð˜ÐÐÐ§Ð•

EMPTYTABLE

ÐŸÐ£Ð¡Ð¢ÐÐ¯Ð¢ÐÐ‘Ð›Ð˜Ð¦Ð

END

ÐšÐžÐÐ•Ð¦

ENDOFPERIOD

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

ESCAPE

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

FALSE

Ð›ÐžÐ–Ð¬

FOR UPDATE [OF]

Ð”Ð›Ð¯ Ð˜Ð—ÐœÐ•ÐÐ•ÐÐ˜Ð¯

FROM

Ð˜Ð—

FULL

ÐŸÐžÐ›ÐÐžÐ•

GROUP BY

Ð¡Ð“Ð Ð£ÐŸÐŸÐ˜Ð ÐžÐ'ÐÐ¢Ð¬ ÐŸÐž

HALFYEAR

ÐŸÐžÐ›Ð£Ð“ÐžÐ”Ð˜Ð•

HAVING

Ð˜ÐœÐ•Ð®Ð©Ð˜Ð•

HIERARCHY

Ð˜Ð•Ð ÐÐ Ð¥Ð˜Ð˜ (for checking whether a catalog belongs to hierarchy

HIERARCHY

Ð˜Ð•Ð ÐÐ Ð¥Ð˜Ð¯ (for ordering by hierarchy)

HOUR

Ð§ÐÐ¡

IN

Ð'

INDEX BY

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

INNER

Ð'ÐÐ£Ð¢Ð Ð•ÐÐÐ•Ð•

INTO

ÐŸÐžÐœÐ•Ð¡Ð¢Ð˜Ð¢Ð¬

IS

Ð•Ð¡Ð¢Ð¬

ISNULL

Ð•Ð¡Ð¢Ð¬NULL

JOIN â€¦ ON

Ð¡ÐžÐ•Ð”Ð˜ÐÐ•ÐÐ˜Ð• â€¦ ÐŸÐž

LEFT

Ð›Ð•Ð'ÐžÐ•

LIKE

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

MAX

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

MIN

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

MINUTE

ÐœÐ˜ÐÐ£Ð¢Ð

MONTH

ÐœÐ•Ð¡Ð¯Ð¦

NOT

ÐÐ•

NUMBER

Ð§Ð˜Ð¡Ð›Ðž

ONLY

Ð¢ÐžÐ›Ð¬ÐšÐž

OR

Ð˜Ð›Ð˜

ORDER BY

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

OUTER

Ð'ÐÐ•Ð¨ÐÐ•Ð•

OVERALL

ÐžÐ‘Ð©Ð˜Ð•

PERIODS

ÐŸÐ•Ð Ð˜ÐžÐ”ÐÐœÐ˜

PRESENTATION

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

QUARTER

ÐšÐ'ÐÐ Ð¢ÐÐ›

REFPRESENTATION

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

REFS

Ð¡Ð¡Ð«Ð›ÐšÐ

RIGHT

ÐŸÐ ÐÐ'ÐžÐ•

SECOND

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

SELECT

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

STRING

Ð¡Ð¢Ð ÐžÐšÐ

SUBSTRING

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

SUM

Ð¡Ð£ÐœÐœÐ

TENDAYS

Ð”Ð•ÐšÐÐ”Ð

THEN

Ð¢ÐžÐ“Ð”Ð

TOP

ÐŸÐ•Ð Ð'Ð«Ð•

TOTALS â€¦ BY

Ð˜Ð¢ÐžÐ“Ð˜ â€¦ ÐŸÐž

TRUE

Ð˜Ð¡Ð¢Ð˜ÐÐ

TYPE

Ð¢Ð˜ÐŸ

UNDEFINED

ÐÐ•ÐžÐŸÐ Ð•Ð”Ð•Ð›Ð•ÐÐž

UNION

ÐžÐ‘ÐªÐ•Ð”Ð˜ÐÐ˜Ð¢Ð¬

VALUE

Ð—ÐÐÐ§Ð•ÐÐ˜Ð•

VALUETYPE

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

WEEK

ÐÐ•Ð”Ð•Ð›Ð¯

WEEKDAY

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

WHEN

ÐšÐžÐ“Ð”Ð

WHERE

Ð“Ð”Ð•

YEAR

Ð“ÐžÐ”

English	Russian
ALL	Ð'Ð¡Ð•
ALLOWED	Ð ÐÐ—Ð Ð•Ð¨Ð•ÐÐÐ«Ð•
AND	Ð˜
AS	ÐšÐÐš
ASC	Ð'ÐžÐ—Ð
AUTOORDER	ÐÐ'Ð¢ÐžÐ£ÐŸÐžÐ Ð¯Ð”ÐžÐ§Ð˜Ð'ÐÐÐ˜Ð•
AVG	Ð¡Ð Ð•Ð”ÐÐ•Ð•
BEGINOFPERIOD	ÐÐÐ§ÐÐ›ÐžÐŸÐ•Ð Ð˜ÐžÐ”Ð
BETWEEN	ÐœÐ•Ð–Ð”Ð£
BOOLEAN	Ð‘Ð£Ð›Ð•Ð'Ðž
CASE	Ð'Ð«Ð‘ÐžÐ
CAST	Ð'Ð«Ð ÐÐ—Ð˜Ð¢Ð¬
COUNT	ÐšÐžÐ›Ð˜Ð§Ð•Ð¡Ð¢Ð'Ðž
DATE	Ð”ÐÐ¢Ð
DATEADD	Ð”ÐžÐ‘ÐÐ'Ð˜Ð¢Ð¬ÐšÐ”ÐÐ¢Ð•
DATEDIFF	Ð ÐÐ—ÐÐžÐ¡Ð¢Ð¬Ð”ÐÐ¢
DATETIME	Ð”ÐÐ¢ÐÐ'Ð Ð•ÐœÐ¯
DAY	Ð”Ð•ÐÐ¬
DAYOFYEAR	Ð”Ð•ÐÐ¬Ð“ÐžÐ”Ð
DESC	Ð£Ð‘Ð«Ð'
DISTINCT	Ð ÐÐ—Ð›Ð˜Ð§ÐÐ«Ð•
DROP	Ð£ÐÐ˜Ð§Ð¢ÐžÐ–Ð˜Ð¢Ð¬
ELSE	Ð˜ÐÐÐ§Ð•
EMPTYTABLE	ÐŸÐ£Ð¡Ð¢ÐÐ¯Ð¢ÐÐ‘Ð›Ð˜Ð¦Ð
END	ÐšÐžÐÐ•Ð¦
ENDOFPERIOD	ÐšÐžÐÐ•Ð¦ÐŸÐ•Ð Ð˜ÐžÐ”Ð
ESCAPE	Ð¡ÐŸÐ•Ð¦Ð¡Ð˜ÐœÐ'ÐžÐ›
FALSE	Ð›ÐžÐ–Ð¬
FOR UPDATE [OF]	Ð”Ð›Ð¯ Ð˜Ð—ÐœÐ•ÐÐ•ÐÐ˜Ð¯
FROM	Ð˜Ð—
FULL	ÐŸÐžÐ›ÐÐžÐ•
GROUP BY	Ð¡Ð“Ð Ð£ÐŸÐŸÐ˜Ð ÐžÐ'ÐÐ¢Ð¬ ÐŸÐž
HALFYEAR	ÐŸÐžÐ›Ð£Ð“ÐžÐ”Ð˜Ð•
HAVING	Ð˜ÐœÐ•Ð®Ð©Ð˜Ð•
HIERARCHY	Ð˜Ð•Ð ÐÐ Ð¥Ð˜Ð˜ (for checking whether a catalog belongs to hierarchy
HIERARCHY	Ð˜Ð•Ð ÐÐ Ð¥Ð˜Ð¯ (for ordering by hierarchy)
HOUR	Ð§ÐÐ¡
IN	Ð'
INDEX BY	Ð˜ÐÐ”Ð•ÐšÐ¡Ð˜Ð ÐžÐ'ÐÐ¢Ð¬ ÐŸÐž
INNER	Ð'ÐÐ£Ð¢Ð Ð•ÐÐÐ•Ð•
INTO	ÐŸÐžÐœÐ•Ð¡Ð¢Ð˜Ð¢Ð¬
IS	Ð•Ð¡Ð¢Ð¬
ISNULL	Ð•Ð¡Ð¢Ð¬NULL
JOIN â€¦ ON	Ð¡ÐžÐ•Ð”Ð˜ÐÐ•ÐÐ˜Ð• â€¦ ÐŸÐž
LEFT	Ð›Ð•Ð'ÐžÐ•
LIKE	ÐŸÐžÐ”ÐžÐ‘ÐÐž
MAX	ÐœÐÐšÐ¡Ð˜ÐœÐ£Ðœ
MIN	ÐœÐ˜ÐÐ˜ÐœÐ£Ðœ
MINUTE	ÐœÐ˜ÐÐ£Ð¢Ð
MONTH	ÐœÐ•Ð¡Ð¯Ð¦
NOT	ÐÐ•
NUMBER	Ð§Ð˜Ð¡Ð›Ðž
ONLY	Ð¢ÐžÐ›Ð¬ÐšÐž
OR	Ð˜Ð›Ð˜
ORDER BY	Ð£ÐŸÐžÐ Ð¯Ð”ÐžÐ§Ð˜Ð¢Ð¬ ÐŸÐž
OUTER	Ð'ÐÐ•Ð¨ÐÐ•Ð•
OVERALL	ÐžÐ‘Ð©Ð˜Ð•
PERIODS	ÐŸÐ•Ð Ð˜ÐžÐ”ÐÐœÐ˜
PRESENTATION	ÐŸÐ Ð•Ð”Ð¡Ð¢ÐÐ'Ð›Ð•ÐÐ˜Ð•
QUARTER	ÐšÐ'ÐÐ Ð¢ÐÐ›
REFPRESENTATION	ÐŸÐ Ð•Ð”Ð¡Ð¢ÐÐ'Ð›Ð•ÐÐ˜Ð•Ð¡Ð¡Ð«Ð›ÐšÐ˜
REFS	Ð¡Ð¡Ð«Ð›ÐšÐ
RIGHT	ÐŸÐ ÐÐ'ÐžÐ•
SECOND	Ð¡Ð•ÐšÐ£ÐÐ”Ð
SELECT	Ð'Ð«Ð‘Ð ÐÐ¢Ð¬
STRING	Ð¡Ð¢Ð ÐžÐšÐ
SUBSTRING	ÐŸÐžÐ”Ð¡Ð¢Ð ÐžÐšÐ
SUM	Ð¡Ð£ÐœÐœÐ
TENDAYS	Ð”Ð•ÐšÐÐ”Ð
THEN	Ð¢ÐžÐ“Ð”Ð
TOP	ÐŸÐ•Ð Ð'Ð«Ð•
TOTALS â€¦ BY	Ð˜Ð¢ÐžÐ“Ð˜ â€¦ ÐŸÐž
TRUE	Ð˜Ð¡Ð¢Ð˜ÐÐ
TYPE	Ð¢Ð˜ÐŸ
UNDEFINED	ÐÐ•ÐžÐŸÐ Ð•Ð”Ð•Ð›Ð•ÐÐž
UNION	ÐžÐ‘ÐªÐ•Ð”Ð˜ÐÐ˜Ð¢Ð¬
VALUE	Ð—ÐÐÐ§Ð•ÐÐ˜Ð•
VALUETYPE	Ð¢Ð˜ÐŸÐ—ÐÐÐ§Ð•ÐÐ˜Ð¯
WEEK	ÐÐ•Ð”Ð•Ð›Ð¯
WEEKDAY	Ð”Ð•ÐÐ¬ÐÐ•Ð”Ð•Ð›Ð˜
WHEN	ÐšÐžÐ“Ð”Ð
WHERE	Ð“Ð”Ð•
YEAR	Ð“ÐžÐ”