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

Back to news
August 24, 2012
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.<br>
<br>
With the addition of new articles, the structure of some library
sections was changed for better navigation. <br>
<br>
The new articles are located in <a
  href="http://1c-dn.com/library/developer_resources/">Developer
  resources</a> and <a href="http://1c-dn.com/library/methodology/">Methodology</a>
sections. Here is a full list of additions.<br>
<br>
<h3>Query language</h3>
<ul>
  <li><a

href="http://1c-dn.com/library/accessing_fields_from_other_fields_using_dot/">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

    Module formatting



    Previous news
    August 15, 2012

    New tutorial for 1C:Enterprise developers

    The first part of a training manual that provides a deep knowledge of configuration objects  of 1C:Enterprise and development techniques.
    Next news
    August 30, 2012

    Partner and 1C:Enterprise developer survey

    1C Company is conducting a survey of partners and developers.