1Ci Support Help Center home page
Submit a request
Sign in
  1. 1Ci Support
  2. 1C:Enterprise Development Standards
  3. Code conventions
  4. Using applied objects and universal value collections

Getting presentations for reference values in a spreadsheet document

  • Using applied objects and universal value collections
    • Search in value collections
    • Using the InformationRegisterRecordsManager object
    • Copying rows between value tables (tabular sections, etc.) with arbitrary structure
    • Document register records recording procedure
    • Getting presentations for reference values in a spreadsheet document
    • Creating applied objects programmatically
    • Using an object module, an object manager module, and common modules
    • Restrictions on the use of export procedures and functions
    • Setting the selection parameters and relations between them for the metadata objects
    • Using FormAttributeToValue and FormDataToValue
See more

Scope: managed applications, mobile applications, and ordinary applications.

Best practices

When you develop a spreadsheet document, for the cells which filling type is Parameter, don't use reference values as parameters. Otherwise, it will require multiple database calls to populate the spreadsheet with the presentations of the reference values.
To reduce database load, it is recommended that you specify value presentations in cell parameters.

The recommendation doesn't apply to the scenario when getting value presentations will also require multiple database calls.

Note that if you get presentations in the query with the Presentation field or the Presentation(<Field name>) function, an implicit connection is established with the object's table. If a field's data type is composite, a connection is established for each data type. This might lead to increased query execution and document generation time. If the number of types is too big, the query will fail since Microsoft SQL Server 2005 cannot support more than 256 tables in one query. For such cases, it is allowed to get presentations for reference values when the spreadsheet document is being generated.

To find the optimal solution how to get value presentations, try different approaches, get empirical data, and use your best judgement.

$$$

  • $$$
  • $$$
© 2020 1C INTERNATIONAL LLC www.1Ci.com Support policy