New sections for 1C developers in 1C:DN Library

1C company expands the knowledge base with a bunch of articles, which are focused on using the query language, specifying access restrictions to application database, and coding conventions.

With the addition of new articles, the structure of some library sections was changed for better navigation.

The new articles are located in Developer resources and Methodology sections. Here is a full list of additions.

Query language

• Accessing fields from other fields using . (dot )
• Bitness of results of expressions and aggregate functions in query language
• Calculating totals by balance fields
• Catalog fields content
• Details on how to use the group inclusion operator
• Display of reference fields
• Sample queries for operations with hierarchical catalogs
• Selection of all included grouping values from a query result
• Sorting in nested queries
• Specifics of connecting to the virtual balances table
• Specifics of DATEDIFF function of the query language
• Specifics of executing SUBSTRING() function of the query language
• Specifics of sorting by reference fields
• Specifics of using "IN HIERARCHY" clause in query language
• Specifics of using the GROUP BY clause
• Specifics of working with the Presentation field and Presentation() function of the query language
• Specifics of working with virtual table of calculation register schedule data
• Splitting query result into time periods
• Using arbitrary expressions in query language totals
• Using filters in queries with virtual tables
• Using FOR UPDATE clause in the query language
• Using the ISNULL() function

Record- and field-level access restrictions

• Data access restrictions based on tabular sections
• Data access restrictions. Operating concepts overview
• Efficient operation of data access restrictions on the record level
• How the changing of values of session parameters and functional options impacts performance of data access restrictions mechanism

Module formatting

• Considerations on using structures as parameters of procedures and functions
• Module structure
• Module texts
• Procedure and function descriptions
• Procedure and function names
• Procedure and function parameters
• Rules of naming variables