1C:Enterprise 8 Script language

The script language allows a developer to create his own application business logic. It has many particulars similar to other script languages, such as Java Script, that makes it easier for coding by beginning developers.

It supports:

• Array Handling
• Assignments
• Booleans
• Comments
• Control flow
• Dates and Time
• Declarations
• Error Handling
• Function Creation
• Global Methods
• Math
• Numbers
• Object Creation
• Operators
• Objects
• Strings
• Preprocessor Instructions
• Value Conversion

Query Language

To provide a developer with a way to use queries to implement his own algorithms 1C:Enterprise 8 framework includes a query language.

A native SQL-like query language, supporting all SQL standard, but extending it with more business tasks-oriented features. The most significant features of the query language are the following:

• Access to fields. If some table fields are of reference type, a developer can reference to them.
• Access to nested tables (tabular parts of documents).
• Auto-ordering.
• Multi-dimensional and multi-layer totals.
• Virtual tables support. The virtual tables provided by the framework allows getting almost ready data for most applied solutions without the need to build complicated queries. For example, such a virtual table can provide balance data by periods at a certain point of time. At that, virtual tables use information stored as much as possible, for example, totals calculated earlier.
• Standard SQL-operations, such as Union, Join, etc.