1C:DN
  • Getting started
  • Downloads
  • Buy online
  • Support
  • News
  • About
  • 1C:Enterprise
  • Partners
  • Applications
  • Knowledge base
  • Learn
  • Developer tools
  • Forum
  • Hello, 1C
    • Introduction
    • If you have everything you need?
    • Infobase
    • Start "programming"
      • Subsystems
      • Catalogs
      • Register
      • Documents
      • Reports
    • Improving the interface
      • Improving subsystems
      • Adjusting the subsystem content
      • Home page
      • Command interface of Main section
      • Managed forms
      • Standard and ordinary attributes
      • Object presentations
      • Quick selection of values
      • Adjusting reports
      • Report variants
    • Functional options
    • Cross-platform design
      • Linux
      • Web client
      • Mobile platform
    • Where and how to study 1C:Enterprise
      • 1C:Enterprise 8 (training version)
    • Business automation
      • 1C:AccountingSuite demo
      • Business automation
      • 1C:Enterprise 8
      • 1C partners
    • Useful online resources
    • About 1C Company
  • Practical developer guide 8.3
    • Overview
      • Target audience
      • How to read this book
      • Distribution package contents
      • Limitations of the training platform version
    • Lesson 1 (0:40). Introduction. Creating an infobase
      • Programming or development?
      • General overview
      • Configurations and applied solutions
      • System operation modes
      • Creating an infobase
      • In Designer mode
        • Introduction to Designer
        • Configuration object tree
        • Understanding configuration objects
        • Adding configuration objects
        • Property palette
        • Debugging in 1C:Enterprise mode
      • In 1C:Enterprise mode
        • Applied solution interface appearance
      • Quiz
    • Lesson 2 (0:45). Subsystems
      • Understanding subsystems
      • Adding subsystems
        • In Designer mode
          • Configuration object name and synonym
          • Adding subsystem icons
      • Applied solution sections panel
        • In 1C:Enterprise mode
      • Specifying section order
        • In Designer mode
        • In 1C:Enterprise mode
      • Theory. Configuration object editor and property palette
      • Quiz
    • Lesson 3 (2:10). Catalogs
      • Understanding catalogs
      • Catalog forms
      • Simple catalogs
        • In Designer mode
          • Configuration object presentations
          • Object affiliation with subsystems
          • Catalog code and description
          • Item creation command
        • In 1C:Enterprise mode
          • Current section commands panel
          • Creating catalog items
      • Customizing applied solution panel view
        • In Designer mode
        • In 1C:Enterprise mode
      • Catalogs with tabular sections
        • In Designer mode
          • Tabular sections
        • In 1C:Enterprise mode
          • Filling tabular sections
      • Hierarchical catalogs
        • In Designer mode
        • In 1C:Enterprise mode
          • Creating hierarchical catalog items
          • Moving items between groups
      • Catalogs with predefined items
        • In Designer mode
          • Quick choice property
          • Predefined items
        • In 1C:Enterprise mode
      • Theory
        • Predefined items
        • Base configuration and database configuration
      • Quiz
    • Lesson 4 (1:30). Documents
      • Understanding documents
      • Document forms
      • Theory. Data types. Type-defining configuration objects
      • The Goods receipt document
        • In Designer mode
          • Adding a document
          • Attributes of reference type
          • "Fill value" property of a configuration object attribute
          • Tabular section fill check
        • In 1C:Enterprise mode
          • Adding Goods receipt documents
      • Theory. Catalogs and documents
      • Automatic recalculation of document totals
        • In Designer mode
          • Document form
          • Event handler
        • In 1C:Enterprise mode
      • A single procedure as a hander for multiple events
        • In Designer mode
          • Common module
        • In 1C:Enterpise mode
      • The Services document
        • In Designer mode
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 5 (2:00). Theory
      • Default forms
      • Event handlers
      • Modules
        • Module types
        • Form module context
      • A form as a script object
      • Event handler procedures in form modules
      • Understanding form module content
      • Understanding 1C:Enterprise script
        • Using Syntax Assistant to analyze script
          • Method #1
          • Method #2
        • Analyzing script with Debugger
      • Objects, objects, objects
      • Server and clients
      • Common module compilation
      • Compilation directives
      • Script execution on the client and on the server
    • Lesson 6 (0:50). Accumulation registers
      • Accumulation register purpose
      • Understanding accumulation registers
      • Adding an accumulation register
        • In Designer mode
          • Creating register records of a document
        • In 1C:Enterprise mode
      • Register records opening command in a document form
        • In Designer mode
        • In 1C:Enterprise mode
      • Creating register records of the Services document
        • In Designer mode
        • In 1C:Enterprise mode
      • Theory. Accessing collection items
      • Quiz
    • Lesson 7 (0:25). A simple report
      • Understanding reports
      • Adding a report
        • In Designer mode
          • Template
          • Data composition schema
          • Data set
          • Query text
          • Report settings
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 8 (0:40). Templates. Editing templates
      • Understanding templates
      • Print form template
        • In Designer mode
        • In 1C:Enterprise mode
      • Editing a template
        • In Designer mode
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 9 (0:50). Periodic information registers
      • Information register purpose
      • Understanding information registers
      • Adding a periodic information register
        • In Designer mode
          • Dimensions and resources
        • In 1C:Enterprise mode
          • Creating information register records
      • Filling prices in documents upon selecting materials or services
        • In Designer mode
          • Creating a function that returns material or service price
          • Calling the function upon material or service selection for filling the price
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 10 (0:40). Enumerations
      • Understanding enumerations
      • Adding enumerations
        • In Designer mode
      • Linking materials and services to values of the MaterialServiceType enumeration
        • In Designer mode
        • In 1C:Enterprise mode
      • Custom presentations for materials and services
        • In Designer mode
        • In 1C:Enterprise mode
      • Recording expenses for materials only
        • In Designer mode
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 11 (1:20). Posting documents across multiple registers
      • Why post a document across multiple registers
      • Adding another accumulation register
        • In Designer mode
      • Posting goods receipts across two registers
        • In Designer mode
          • Modifying the posting procedure
          • Adding the command that opens register records
        • In 1C:Enterprise mode
      • Posting Services documents across two registers
        • In Designer mode
          • Adding the document attribute
          • Modifying the posting procedure
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 12 (0:40). Turnover accumulation registers
      • Why we need another register
      • Understanding turnover accumulation registers
      • Adding turnover accumulation registers
        • In Designer mode
      • Posting Services documents across three registers
        • In Designer mode
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 13 (4:30). Reports
      • Theory. Data access methods
        • Using queries
          • Query data sources
          • Query language
        • Data composition system
      • Selecting data from a single table
        • In Designer mode
          • Query for a data set
            • Field aliases
            • Records order
          • Analyzing query text
          • Settings
        • In 1C:Enterprise mode
      • Selecting data from two tables
        • In Designer mode
          • Query for a data set
            • Left join of two tables
            • Record filter condition
            • Field aliases
            • Records order
          • Analyzing query text
          • Resources
          • Parameters
          • Settings
          • Quick user settings
        • In 1C:Enterprise mode
        • Settings in Designer and settings in 1C:Enterprise mode
          • Conditional appearance
            • In Designer mode
            • In 1C:Enterprise mode
          • User settings
            • In Designer mode
          • Filter
            • In Designer mode
            • In 1C:Enterprise mode
      • Breaking down by days in the selected period
        • In Designer mode
          • Query for a data set
            • Virtual table parameters
          • Analyzing query text
          • Resources
          • Parameters
          • Settings
        • In 1C:Enterprise mode
        • Breaking down by date within the selected period
          • In Designer
          • In 1C:Enterprise mode
        • Report options
          • Charts
          • In Designer mode
          • In 1C:Enterprise mode
      • Getting current values from a periodic information register
        • In Designer mode
          • Query for a data set
            • Virtual table parameters
            • Left join of tables
            • Field aliases
          • Analyzing query text
          • Resources
          • Parameters
          • Settings
        • In 1C:Enterprise mode
      • Using calculated fields in reports
        • In Designer mode
          • Query for a data set
          • Calculated fields
          • Resources
          • Settings
        • In 1C:Enterprise mode
      • Displaying data as a spreadsheet
        • In Designer mode
          • Query for a data set
          • Analyzing query text
          • Resources
          • Settings
        • In 1C:Enterprise mode
      • Theory. Virtual query tables
      • Quiz
    • Lesson 14 (3:20). Optimization of posting the Services document
      • Theory. Referential data usage specifics
      • Improving posting performance
        • In Designer mode
        • In 1C:Enterprise mode
      • Automatic cost calculation
        • In Designer mode
        • In 1C:Enterprise mode
      • Theory
        • Quick viewing of a query result
        • Real-time and regular document posting
        • "Point in time" concept
      • Checking the balances
        • In Designer mode
      • Locking data that is read and modified during posting
        • In Designer mode
      • Marking custom module regions
      • In 1C:Enterprise mode
      • Theory. Understanding cache
        • Standard cache
        • Transactional cache
      • Quiz
    • Lesson 15 (2:50). Charts of characteristic types
      • The task at hand
      • Understanding charts of characteristic types
      • Logical relation between the objects
      • Creating new configuration objects
        • In Designer mode
          • Description of material option characteristics
      • Modifying configuration objects
        • The MaterialOptions catalog
          • In 1C:Enterprise mode
          • In Designer mode
          • In 1C:Enterprise mode
          • In Designer mode
          • In 1C:Enterprise mode
        • The MaterialPropertyValues information register
          • In 1C:Enterprise mode
          • In Designer mode
          • In 1C:Enterprise mode
          • In Designer mode
          • In 1C:Enterprise mode
      • Creating material characteristic types
        • In 1C:Enterprise mode
      • Modifying accounting functionality
        • The BalanceOfMaterials register
          • In Designer mode
        • The GoodsReceipt document
          • In Designer mode
        • The Services document
          • In Designer mode
      • Material receipt and expense with property sets specified
        • In 1C:Enterprise mode
      • Report with characteristics
        • In Designer mode
          • Query for a data set
          • Resources
          • Settings
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 16 (1:50). Accounting
      • Using charts of characteristic types in accounting
      • Adding a chart of characteristic types
        • In Designer mode
      • Understanding charts of accounts
      • Adding a chart of accounts
        • In Designer mode
      • Understanding accounting registers
      • Adding an accounting register
        • In Designer mode
      • Modifying the GoodsReceipt document
        • In Designer mode
        • In 1C:Enterprise mode
      • Modifying the Services document
        • In Designer mode
        • In 1C:Enterprise mode
      • Trial balance
        • In Designer mode
          • Query for a data set
          • Resources
          • Parameters
          • Settings
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 17 (1:00). Charts of calculation types and calculation registers
      • Chart of calculation types and calculation register purposes
        • Dependency by base period
        • Displacement by action period
      • Understanding charts of calculation types
      • Adding a chart of calculation types
        • In Designer mode
      • Understanding calculation registers
        • Periodicity
        • Displacement by action period
        • Dependency by base period
          • Dependency by action period
          • Dependency by registration period
      • Adding a calculation register
        • In Designer mode
        • In 1C:Enterprise mode
        • In Designer mode
      • Quiz
    • Lesson 18 (3:40). Using calculation registers
      • Adding a document that describes accruals
        • In Designer mode
        • In 1C:Enterprise mode
      • Examples of displacement and dependency by base period
        • Recalculation report
          • In Designer mode
        • Dependency by base period
          • In 1C:Enterprise mode
        • Displacement by action period
          • In 1C:Enterprise mode
      • Procedure for calculating calculation register records
        • In Designer mode
        • In 1C:Enterprise mode
      • Employee accruals report
        • In Designer mode
          • Query for a data set
          • Resources
          • Settings
        • In 1C:Enterprise mode
      • Recalculations
        • In Designer mode
        • In 1C:Enterprise mode
      • Gantt chart
        • In Designer mode
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 19 (0:40). Database search
      • Full-text search basics
      • Creating a full-text index
        • In Designer mode
        • In 1C:Enterprise mode
      • Database search examples
        • In 1C:Enterprise mode
      • Search during input by string
        • In Designer mode
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 20 (0:35). Scheduled jobs
      • The task at hand
      • Understanding scheduled jobs
      • Creating scheduled jobs
        • In Designer mode
      • Running scheduled jobs
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 21 (0:40). Editing register records in document forms
      • In Designer mode
      • In 1C:Enterprise mode
      • Editing register records from 1C:Enterprise script
        • Writing register records from a form
          • In Designer mode
          • In 1C:Enterprise mode
        • Writing register records from 1C:Enterprise script
          • In Designer mode
          • In 1C:Enterprise mode
        • Choosing handler locations
      • Quiz
    • Lesson 22 (1:50). Users and their roles
      • Understanding roles
      • Creating roles
        • In Designer mode
          • Administrator
          • CEO
          • Technician
          • Payroll accountant
          • Accountant
          • Rights to run client applications
      • Adding users
        • In Designer mode
      • Record and database field-level data access restrictions
        • In Designer mode
        • In 1C:Enterprise mode
        • In Designer mode
        • In 1C:Enterprise mode
        • In Designer mode
        • In 1C:Enterprise mode
        • In Designer mode
      • Quiz
    • Lesson 23 (1:10). Start page and command interface customization
      • Customizing section command interfaces
        • In Designer mode
        • In 1C:Enterprise mode
      • Quick menu. Customizing the start page
        • In Designer mode
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 24 (6:10). Data exchange
      • Understanding data exchange
        • Understanding exchange plans
        • XML serialization
        • Reading and writing XML documents
      • Universal data exchange
        • Creating a constant for data exchange
          • In Designer mode
        • Updating configuration objects involved in data exchange
          • In Designer mode
        • Adding an exchange plan
          • In Designer mode
        • Creating data exchange procedures
          • In Designer mode
          • Data writing procedure
          • Data reading procedure
        • Testing data exchange
          • In Designer mode
          • In 1C:Enterprise mode
          • Running the branch infobase
            • In Designer mode
            • In 1C:Enterprise mode
      • Distributed infobases
        • Overview
        • The task at hand
        • Interactive exchange
          • In Designer mode
          • In 1C:Enterprise mode
          • Running the department infobase
            • In Designer mode
            • In 1C:Enterprise mode
        • Script-based exchange
          • In Designer mode
        • Modifying distributed infobase node structure
      • Quiz
    • Lesson 25 (0:30). Functional options
      • Accounting and Payroll options
        • In Designer mode
        • In 1C:Enterprise mode
      • Accounting by customers option
        • In Designer mode
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 26 (2:00). Picking list items, avoiding modal windows, and generating data based on other data
      • Picking list items
        • Picking a single item
          • In Designer mode
          • In 1C:Enterprise mode
        • Picking multiple items
          • In Designer mode
          • In 1C:Enterprise mode
        • Picking with multiple selection
          • In Designer mode
          • In 1C:Enterprise mode
        • Picking multiple items with multiple selection
          • In Designer mode
          • In 1C:Enterprise mode
        • Using the NotifyChoice() method
      • Avoiding modal windows
        • Theory
        • Requesting user input in a form command
          • In Designer mode
          • In 1C:Enterprise mode
        • Requesting user input in an event handler
          • In 1C:Enterprise mode
      • Generating data based on other data
        • Creating a document generation command
          • In Designer mode
          • In 1C:Enterprise mode
        • Generated objects
        • Understanding filter criteria
        • Getting generated objects
          • In Designer mode
          • In 1C:Enterprise mode
      • Quiz
    • Lesson 27 (2:10). Form development techniques
      • Form data and controls
      • Form data types
      • Related lists
        • In Designer mode
        • In 1C:Enterprise mode
      • Formatting rows in list forms
        • In Designer mode
        • In 1C:Enterprise mode
        • In Designer mode
        • In 1C:Enterprise mode
      • Calculated columns in lists
        • In Designer mode
        • In 1C:Enterprise mode
      • Selection list in a text box
        • In Designer mode
        • In 1C:Enterprise mode
      • Choice form for a field with a reference attribute
        • In Designer mode
        • In 1C:Enterprise mode
      • Attribute fill check
        • Automatic fill check
          • In Designer mode
          • In 1C:Enterprise mode
        • 1C:Enterprise script-based fill check
          • In Designer mode
          • In 1C:Enterprise mode
      • Using parameterized commands
        • In Designer mode
        • In 1C:Enterprise mode
      • Opening a list form with the specified filter
        • In Designer mode
        • In 1C:Enterprise mode
        • In Designer mode
        • In 1C:Enterprise mode
      • Quiz
    • Lesson 28 (2:00). Form customization techniques
      • Form editor
      • Implementing a custom form for the Services document
        • In Designer mode
        • In 1C:Enterprise mode
        • In Designer mode
        • In 1C:Enterprise mode
        • In Designer mode
        • In 1C:Enterprise mode
      • Adding a tumbler switch to a form
        • In Designer mode
        • In 1C:Enterprise mode
      • Grouping list data
        • In Designer mode
        • In 1C:Enterprise mode
      • Quiz
    • Quick developer reference
      • 1C:Enterprise script objects used for operations with applied data
      • Manipulating object data
      • Constants
        • 1C:Enterprise script objects used for operations with constants
        • Event sequence for writing constants from constant forms (save and close)
      • Catalogs
        • 1C:Enterprise script objects used for operations with catalogs
        • Event sequence for writing catalog items from item forms (save and close)
      • Documents
        • 1C:Enterprise script objects used for operations with documents
        • Event sequence for writing documents from document forms
        • Event sequence for posting documents from document forms (post and close)
        • Event sequence for canceling document posting from document forms
      • Enumerations
        • 1C:Enterprise script objects used for operations with enumerations
      • Charts of characteristic types
        • 1C:Enterprise script objects used for operations with charts of characteristic types
        • Event sequence for writing characteristic types from item forms (save and close)
      • Charts of accounts
        • 1C:Enterprise script objects used for operations with charts of accounts
        • Event sequence for writing accounts from account forms (save and close)
      • Charts of calculation types
        • 1C:Enterprise script objects used for operations with charts of calculation types
        • Event sequence for writing calculation types from calculation type forms (save and close)
      • Information registers
        • 1C:Enterprise script objects used for operations with information registers
        • Event sequence for writing data from information register record forms (save and close)
        • Event sequence for writing data from information register record set forms (save and close)
      • Accumulation registers
        • 1C:Enterprise script objects used for operations with accumulation registers
        • Event sequence for writing accumulation register record sets from record set forms
      • Accounting registers
        • 1C:Enterprise script objects used for operations with accounting registers
        • Event sequence for writing accounting register record sets from record set forms
      • Calculation registers
        • 1C:Enterprise script objects used for operations with calculation registers
        • Event sequence for writing data from calculation register record set forms
      • Exchange plans
        • 1C:Enterprise script objects used for operations with exchange plans
        • Event sequence for writing exchange plan nodes from node forms (save and close)
    • Glossary
    • Copyright notice
  • Building a mobile application (1C mobile application)
    • Introduction
    • Do you have everything you need?
    • Infobase
    • Start programming
      • Catalogs
      • Registers
      • Documents
      • Desktop
    • Improving desktop functionality
    • Improving interface
      • Main section command interface
      • Managed forms
      • Adjusting document forms
      • Adding desktop buttons
      • Updating desktop tables
      • Final interface tuning
    • Cross-platform design
      • Linux
      • Web client
      • Mobile platform
    • Homework
      • Homework 1
      • Homework 2
      • Homework 3
    • Mobile application building example
      • Installing and setting up third-party software
      • Installing and setting up Mobile application builder
      • Building the application
      • Testing the application
    • Where and how to study 1C:Enterprise
      • 1C:AccountingSuite demo
      • 1C:Enterprise 8 (training version)
    • Business automation
    • 1C:Enterprise 8
    • 1C partners
    • Useful online resources
    • About 1C Company
  • 1C:Enterprise documentation
    • 1C:Enterprise Administrative Service API
    • 1C:Enterprise Administrator Guide
    • 1C:Enterprise Development Tools
      • Chapter 1. What is 1C:Enterprise Development Tools
      • Chapter 2. Using 1C:Enterprise Development Tools
        • System requirements
          • 32-bit system requirements
          • 64-bit system requirements
        • Getting started
        • 1C:Enterprise perspective
          • Overview
          • 1C:Enterprise Navigator view
            • Overview
            • Project editor
            • Creating configurations
            • Importing configurations
            • Saving configurations
            • Operations with configuration objects
              • Overview
              • Creating configuration objects
              • Deleting configuration objects
              • Editing object properties
              • Searching for configuration objects
          • Infobases view
          • Web Servers view
          • Launch and debug configurations
            • Overview
            • Launch configurations
            • Debug configurations
          • Editors
            • Object editor
            • Properties view (property palette)
            • 1C:Enterprise script editor
            • Role editor
            • Command interface editor
            • Query wizard
          • Publishing infobases
          • Configuration Problems view
        • Debug perspective
          • Overview
          • 1C:Enterprise debug server
          • Available tools
      • Chapter 3. 1C:Enterprise Development Tools setup
        • Overview
        • Available 1C:Enterprise versions
        • Embedded web server
      • Chapter 4. Beta version details and limitations
      • Chapter 5. Bug reporting guidelines
      • Chapter 6. Installation and setup guidelines
    • Add-in Development Technology
      • Introduction
      • Delivery kit directory structure
      • Creating add-ins with Native API technology
        • Add-in interface
        • Localization
        • 1C:Enterprise interface
        • Mapping between tVariant and 1C:Enterprise types
        • Specifics of add-in development using Native API
          • Publishing settings for 1C:Enterprise mobile platform
            • Windows Runtime
            • Android
            • iOS
            • Signing add-ins with developer certificates
            • Static library
      • Creating add-ins with COM technology
        • Creating add-ins with COM technology
        • Initializing and unloading add-ins
        • 1C:Enterprise script extension
        • Localization
        • Using COM VARIANT type in data exchange
          • Calling add-in functions
          • Returning values from add-ins
          • Calling 1C:Enterprise object methods from add-ins
        • COM interfaces of 1C:Enterprise
          • Saving add-in object parameters
          • Notification messages about object states
          • Dialog boxes
          • Getting platform info
          • External events
          • Status bar operations
        • Creating windows in 1C:Enterprise environment
        • Accessing 1C:Enterprise methods and properties using OLE automation
        • Methods and properties available through OLE Automation
        • Specifics of add-in development using COM
      • Preparing add-ins for working with the web client
        • Add-ins for Microsoft Internet Explorer
          • Creating adapters for Microsoft Internet Explorer
          • Creating installer packages for Miscrosoft Internet Explorer
        • Add-ins for Google Chrome and Mozilla Firefox
          • Creating adapters for Google Chrome and Mozilla Firefox
          • Creating installer packages for Google Chrome and Mozilla Firefox
        • Add-ins for Safari
          • Creating adapters for Safari
          • Creating installer packages for Safari
      • Preparing add-ins for loading them to configurations
        • MANIFEST.XML file description
        • IOS_MANIFEST_EXTENSIONS.XML file description
        • ANDROID_MANIFEST_EXTENSIONS.XML file description
        • WINDOWS_RT_MANIFEST_EXTENSIONS.XML and WINDOWS_RT_PHONE_MANIFEST_EXTENSIONS.XML file descriptions
        • 1C:Enterprise add-in naming rules
        • Add-in limitations
      • Example descriptions
        • 1C:Enterprise add-in examples for desktop computer
          • Properties
          • Methods
        • 1C:Enterprise add-in example for mobile platform
          • Properties
          • Methods
          • Events
        • Development tools
    • 1C:Enterprise Administrator Guide. Client/Server Mode
    • 1C:Enterprise Developer Guide
    • 1C:Enterprise Software License Acquisition Guide
    • 1C:Enterprise User Manual
      • Introduction
        • Overview
          • Note types
          • Conventions
        • What you need to know
        • Books included in the documentation
          • Update and migration notes delivered with 1C:Enterprise
        • 1C:Enterprise system
        • 1C:Developer Network
      • Chapter 1. 1C:Enterprise overview
      • Chapter 2. Installation and update
        • Installing 1C:Enterprise
          • Installing the platform
          • Selecting interface language
        • Installing configurations
        • Obtaining licenses
        • Linux installation specifics
      • Chapter 3. Getting started
        • Starting applications
        • Logging on
          • Starting the web client
          • Specifying connection speed
        • Adding infobases
          • Creating infobases
      • Chapter 4. User interface
        • Forms in tabs
          • Main window
          • Desktop
          • Sections panel
          • Navigation panel
          • Actions panel
          • Information panel
          • System commands area
          • Functions menu
          • Auxiliary windows
            • Navigation in auxiliary windows
            • Form command bar
        • Forms in separate windows
          • Main window
          • System commands area
          • Auxiliary windows
      • Chapter 5. Forms
        • General form operations
        • Fields
          • Text boxes
            • String
            • Number
            • Date
            • Multiple data types
            • Selecting object value
            • Searching for a value in a text box
              • Using full-text search
              • Clearing the selected value
          • Check boxes
          • Radio buttons
        • Tumblers
        • Progress bars
        • Sliders
        • Hyperlinks
        • Buttons
        • Tables
        • Groups
          • Command bars
          • Tabs
        • Charts
        • Text document fields
        • HTML document fields
        • Graphical schema fields
        • Image fields
        • Spreadsheet document fields
        • Formatted document fields
        • Planner fields
          • Adding items
          • Editing items
            • Moving items
            • Scheduling items
          • Deleting items
        • Drag-and-drop operations
        • Saving form values
        • Specific features of some forms
      • Chapter 6. Lists
        • Viewing lists
          • Hierarchical lists
        • Creating list items
          • Creating list folders
          • Copying list items
        • Editing list items
          • Moving list items between folders
          • Selecting values from lists
            • Understanding predefined list items
          • Searching lists
        • Customizing lists
          • Filtering lists
          • Sorting lists
          • Grouping list items
          • Using conditional appearance in lists
            • Saving list settings between sessions
          • Specifying time period in lists
            • Selecting a custom period
              • Adding months to a period/Removing months from a period
            • Selecting a period using arrow keys
            • Selecting a standard period
        • Exporting lists
      • Chapter 7. Data management
        • Numbering items
        • Generating objects based on other objects
        • Deleting items or folders (setting deletion marks)
        • Managing external source data
        • Using print forms
        • Understanding access conflicts
        • Managing documents and document journals
          • Viewing document journals
          • Adding documents from document journals
          • Specifying document date and time
          • Posting documents
          • Understanding unpostable documents
          • Viewing document register records
        • Business processes
          • Viewing business process lists
          • Viewing task lists
          • Completing tasks
      • Chapter 8. Reports
        • Customizing reports
        • Report options
        • Managing reports
          • Using quick settings
          • Using regular settings
            • Filtering reports
            • Sorting reports
              • Sorting example
            • Using conditional appearance in reports
              • Conditional appearance example
            • Grouping report items
              • Grouping example
        • Drilling down
      • Chapter 9. Report options
        • Customizing general report settings
        • Customizing report structure
          • Customizing report structure items
          • Customizing settings items
            • Available fields
            • Parameters
            • User-defined fields
            • Grouped fields
              • Grouped auto fields
            • Fields
            • Selection auto field
            • Filter
              • Comparison types
              • Combining filter conditions
            • Sorting
            • Conditional appearance
            • Additional settings
        • Customizing settings item visibility
      • Chapter 10. Service features
        • Links
        • Favorites
          • Customizing favorites
        • History
        • "All functions" menu
        • Notifications
        • Messages
        • Progress indicators
        • Calculator
          • Clipboard
        • Calendar
        • File comparison
          • Comparing text files
          • Comparing spreadsheet documents
        • Temporary locks
        • Error messages
      • Chapter 11. Customizing applications
        • Customizing user interface
          • Customizing desktop
          • Customizing panel view
          • Customizing sections panel
          • Customizing navigation panel
          • Customizing actions panel
          • Customizing system commands area
            • Customizing system commands area for auxiliary windows
              • Toolbars tab
              • Commands tab
        • Customizing forms
          • Form customization example
        • Customizing system options
        • Switching between application windows
          • Customizing text and spreadsheet document windows
          • Restoring window positions
      • Chapter 12. Getting help
        • Help window
          • Viewing help
          • Searching help
          • Printing help topics
        • "About" window
      • Chapter 13. Search expressions
      • Chapter 14. Web client
        • Starting web client
          • Web client window
          • Printing in web client
          • File operations in web client
        • Web client specifics
          • Saving documents
          • Switching between tabs
          • Web client windows
          • Other specifics
            • Selecting slow connection mode
            • File operations
            • Graphical schema operations
            • Spreadsheet document operations
              • Printing spreadsheet documents
            • Image fields
            • Progress indicator window
            • Notifications
            • Activating windows
            • Other specifics
          • iPad specifics
        • Microsoft Internet Explorer setup
          • Installing file system extension
        • Mozilla Firefox setup
          • Specifying language settings
        • Google Chrome setup
        • Safari setup
      • Chapter 15. Slow connection mode
      • Chapter 16. Ordinary application mode
        • Interface
        • "Operations" menu
          • Customizing lists
            • Filtering and sorting lists
              • Specifying filter settings
                • Setting filter by current value
                • Clearing filters
              • Specifying sorting order
            • Customizing lists
          • Reports
            • Report settings wizard
          • Customizing reports
        • Service features
          • Specifying options
            • Specifying general options
            • Specifying text editor options
            • Specifying help display options
            • Specifying system options
          • Toolbars
          • Toolbar types
          • Managing toolbars
            • The "Toolbars" tab
            • Creating toolbars
            • Renaming toolbars
            • Deleting toolbars
          • Specifying user options
        • Saving event log
        • Managing window layout
          • Window bar
            • Managing windows
          • Service windows
            • Immediate window
            • Message window
        • Window states (positions)
      • Appendix 1. Data composition system expression language
        • Literals
        • String
        • Number
        • Date
        • Boolean
        • Value
        • Fields
        • Parameters
        • Operations with numbers
          • Unary +
          • Binary +
          • Multiplication
          • Division
          • Remainder
        • Operations with strings
          • Concatenation (Binary +)
          • LIKE
        • Comparison operations
          • EQUAL
          • NOT EQUAL
          • LESS THAN
          • MORE THAN
          • LESS OR EQUAL
          • GREATER OR EQUAL
          • IN (for values)
          • IN (for data sets)
          • IS NULL
          • IS NOT NULL
        • Logical operations
          • NOT
          • AND
          • OR
        • Aggregate functions
          • SUM
          • COUNT
          • COUNT (DISTINCT)
          • MAX
          • MIN
          • AVG
          • ARRAY
          • VALUETABLE
          • GROUPPROCESSING
          • GROUPBY
          • GETPART
          • ORDER
          • JOINSTRINGS
          • Every
          • Any
          • Stddev_Pop
          • Stddev_Samp
          • Var_Samp
          • Var_Pop
          • Covar_Pop
          • Covar_Samp
          • Corr
          • Regr_Slope
          • Regr_Intercept
          • Regr_Count
          • Regr_R2
          • Regr_AvgX
          • Regr_AvgY
          • Regr_SXX
          • Regr_SYY
          • Regr_SXY
          • Rank
          • ClassificationABC
        • Other operations
          • CASE operation
          • Rules for comparing two values
          • Operations with NULL value
          • Operation priorities
        • Functions
          • EVAL
          • EVALEXPRESSION
          • Parameter usage example
            • LEVEL
            • LEVELINGROUP
            • VALUEISFILLED
            • SERIALNUMBER
            • GROUPSERIALNUMBER
            • FORMAT
            • BEGINOFPERIOD
            • ENDOFPERIOD
            • DATEADD
            • DATEDIFF
            • CURRENTDATE
            • SUBSTRING
            • STRINGLENGTH
            • YEAR
            • QUARTER
            • MONTH
            • DAYOFYEAR
            • DAY
            • WEEK
            • WEEKDAY
            • HOUR
            • MINUTE
            • SECOND
            • CAST
            • ISNULL
            • Cos
            • ACos
            • Sin
            • ASin
            • Tan
            • ATan
            • Exp
            • Log
            • Log10
            • Pow
            • Sqrt
            • Round
            • Int
      • Appendix 2. Text editor
        • Creating and opening text documents
        • Selecting text document extensions
        • Entering and editing text
          • Moving insertion point
          • Going to line by number
          • Using bookmarks
          • Selecting text fragments
          • Operations with selected text
          • Deleting text
          • Adding page breaks
          • Canceling changes
          • Using search and replacement
          • Saving text documents
          • Printing text documents
          • Closing text documents
      • Appendix 3. Spreadsheet document editor
        • Understanding spreadsheet documents
        • Managing spreadsheet documents
        • Creating and opening spreadsheet documents
          • Importing Microsoft Excel and OpenDocument spreadsheets
        • Saving spreadsheet documents
        • Closing spreadsheet documents
        • Viewing spreadsheet documents
          • Names
          • Entering cell text
        • Selecting cells, rows, and columns
        • Using search and replacement
        • Changing row height and column width in spreadsheet documents
        • Moving and copying cells
        • Adding and deleting cells
        • Splitting cells
        • Clearing cells
        • Setting custom cell width for each row
        • Hiding and showing rows and columns
        • Merging cells
        • Managing named spreadsheet document areas
          • Creating named areas
          • Viewing named areas
          • Removing named areas
          • Resizing named areas
        • Managing spreadsheet document groups
          • Creating groups
          • Viewing groups
          • Removing groups
          • Resizing groups. Parent and nested groups
        • Using graphical objects
          • Adding graphical objects
          • Docking graphical objects
          • Selecting and resizing graphical objects
          • Aligning graphical object groups
          • Setting graphical object group size
          • Moving and copying graphical objects
          • Changing graphical object order
          • Deleting graphical objects
          • Grouping graphical objects
          • Naming graphical objects
          • Managing charts
          • Creating charts
          • Specifying chart data area
        • Managing OLE objects
        • Using spreadsheet documents as templates
        • Designing templates
        • Specifying print settings
        • Specifying headers and footers
        • Specifying pagination
        • Repeating rows and columns on each page
        • Specifying print area
        • Specifying page settings
        • Printing spreadsheet documents
        • Editing spreadsheet document and cell properties
          • Editing spreadsheet document properties
          • Specifying background picture
          • Specifying print area
          • Repeating rows and columns on each page
        • Specifying spreadsheet document cell properties
          • Specifying general properties
          • Specifying value properties
          • Specifying alignment properties
          • Specifying appearance properties
          • Specifying picture properties
      • Appendix 4. HTML document editor
        • Understanding HTML document editor
        • Creating HTML documents
        • Saving HTML documents
        • Editing HTML documents
        • Adding text to HTML documents
        • Formatting text in HTML documents
        • Managing tables in HTML documents
        • Adding pictures to HTML documents
        • Adding marquees
        • Adding hyperlinks
        • Adding bookmarks
        • Adding horizontal lines
        • Formatting HTML documents
        • Editing HTML document source code
        • Previewing HTML documents
      • Appendix 5. Graphical schema editor
        • Editing graphical schemas
        • Adding graphical schema items
          • Copying graphical schema items
        • Using grid
        • Managing groups of selected items
          • Specifying graphical schema item alignment
          • Distributing graphical schema items
          • Specifying graphical schema item size
          • Specifying graphical schema item order
          • Scaling graphical schemas
          • Scrolling graphical schemas
          • Printing graphical schemas
        • Specifying graphical schema properties
          • Specifying alignment properties
          • Specifying edit properties
        • Graphical schema items
          • Specifying general properties
          • Specifying appearance properties
          • Specifying behavior properties
          • Specifying location properties
          • Decorative lines
          • Specifying appearance properties
          • Specifying behavior properties
          • Decorations
          • Specifying appearance properties
          • Activities
          • Specifying addressing properties
          • Splitting points
          • Condition points
          • End points
          • Start points
          • Joins
          • Sub-business process points
          • Data processor points
          • Switches
          • Specifying transition properties
      • Appendix 6. Geographical schema editor
        • Creating geographical schemas
        • Saving geographical schemas
        • Customizing geographical schemas
          • Customizing legend items
          • Specifying geographical schema object properties
        • Specifying geographical schema properties
          • Specifying format properties
          • Specifying series properties
        • Specifying geographical schema title properties
          • Specifying format properties
        • Specifying geographical schema legend properties
          • Specifying format properties
        • Using search and replacement
    • 1C:Enterprise User Manual. Taxi Interface
      • Introduction
        • Overview
          • Note types
          • Conventions
        • What you need to know
      • Chapter 1. Taxi interface
        • Start page
        • Sections panel
          • Current section functions panel
          • Navigation
          • Actions
        • Opened items panel
        • Tools panel
        • System command area
        • Object form
          • Form navigation panel
          • Form command bar
      • Chapter 2. Forms
        • General form operations
        • Fields
          • Text boxes
            • String
            • Number
            • Date
            • Multiple data types
            • Selecting object value
          • Check boxes
          • Radio buttons
        • Tumblers
        • Progress bars
        • Sliders
        • Hyperlinks
        • Buttons
        • Tables
        • Groups
          • Command bars
          • Tabs
        • Charts
        • Text document fields
        • HTML document fields
        • Graphical schema fields
        • Image fields
        • Spreadsheet document fields
        • Formatted document fields
        • Planner fields
          • Adding items
          • Editing items
            • Moving items
            • Scheduling items
          • Deleting items
        • Saving form values
      • Chapter 3. Lists
        • Viewing lists
          • Hierarchical lists
        • Creating list items
          • Creating list folders
          • Copying list items
        • Editing list items
          • Moving list items between folders
          • Selecting values from lists
            • Understanding predefined list items
          • Searching lists
        • Customizing lists
          • Filtering lists
          • Sorting lists
          • Grouping list items
          • Using conditional appearance in lists
            • Saving list settings between sessions
          • Specifying time period in lists
            • Selecting a custom period
            • Adding or removing months
            • Selecting a period using arrow keys
            • Selecting a standard period
        • Exporting lists
      • Chapter 4. Data management
        • Numbering items
        • Generating objects based on other objects
        • Deleting items or folders (setting deletion marks)
        • Managing external source data
        • Using print forms
        • Understanding access conflicts
        • Managing documents and document journals
          • Viewing document journals
          • Adding documents from document journals
          • Specifying document date and time
          • Posting documents
          • Understanding unpostable documents
          • Viewing document register records
        • Business processes
          • Viewing business process lists
          • Viewing task lists
          • Completing tasks
      • Chapter 5. Reports
        • Customizing reports
        • Using report options
        • Managing reports
          • Using quick settings
          • Using regular settings
            • Filtering reports
            • Sorting reports
              • Sorting example
            • Using conditional appearance in reports
              • Conditional appearance example
            • Grouping report items
              • Grouping example
        • Drilling down
      • Chapter 6. Report options
        • Customizing general report settings
        • Customizing report structure
          • Customizing report structure items
          • Customizing settings items
            • Available fields
            • Parameters
            • User-defined fields
            • Grouped fields
            • Fields
            • Selection auto field
            • Filter
            • Sorting
            • Conditional appearance
            • Additional settings
        • Customizing settings item visibility
      • Chapter 7. Service features
        • Search
        • Links
        • Favorites
        • History
        • "All functions" menu
        • Notifications
        • Messages
        • Progress indicators
        • Calculator
          • Clipboard
        • Calendar
        • Temporary locks
        • File comparison
          • Comparing text files
          • Comparing spreadsheet documents
        • Error messages
      • Chapter 8. Customizing applications
        • Customizing user interface
          • Customizing start page
          • Customizing panel view
          • Customizing sections panel
          • Customizing navigation panel
          • Customizing actions panel
          • Customizing panel layout
          • Customizing system commands area
        • Customizing forms
          • Form customization example
        • Customizing system options
        • Customizing window layout
          • Switching between application windows
          • Viewing two windows simultaneously
          • Docking windows
          • Showing two windows side-by-side
      • Chapter 9. Getting help
        • Help window
          • Viewing help
          • Searching help
          • Printing help topics
        • "About" window
      • Chapter 10. Search expressions
    • AutoRun Application
    • System requirements
    • New functionality and changes
      • Version 8.3.14
        • New functionality and changes
        • New functionality and changes in the 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile version of 1C:Enterprise
        • Changes in demo configurations
        • Changes performed after version publication
        • Transition from the previous version to the version 8.3.14
      • Version 8.3.13
        • New functionality and changes
        • New functionality and changes in the 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile version of 1C:Enterprise
        • Library updates
        • Changes in demo configurations
        • Changes performed after version publication
        • Transition from the previous version to the version 8.3.13
      • Version 8.3.12
        • New functionality and changes
        • New functionality and changes in the 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile version of 1C:Enterprise
        • Changes in demo configurations
        • Changes performed after version publication
        • Transition from the previous version to the version 8.3.12
      • Version 8.3.11
        • New functionality and changes
        • New functionality and changes in the 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile platform
        • Library updates
        • Transition from the previous version to the version 8.3.11
      • Version 8.3.10
        • New functionality and changes
        • New functionality and changes in the 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile platform
        • Library updates
        • Transition from the previous version to the version 8.3.10
      • Version 8.3.9
        • New functionality and changes
        • New functionality and changes in the 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile platform
        • Library updates
        • Transition from the previous version to the version 8.3.9
      • Version 8.3.8
        • New functionality and changes
        • New functionality and changes in the 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile platform
        • Library updates
        • Transition from the previous version to the version 8.3.8
      • Version 8.3.7
        • New functionality and changes
        • New functionality and changes in the 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile platform
        • Library updates
        • Transition from the previous version to the version 8.3.7
      • Version 8.3.6
        • New functionality and changes
        • New functionality and changes in the 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile platform
        • Library updates
        • Transition from the previous version to the version 8.3.6
      • Version 8.3.5
        • New functionality and changes
        • New functionality and changes in 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile platform
        • Transition from the previous version to the version 8.3.5
      • Version 8.3.4
        • New functionality and changes
        • New functionality and changes in 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile platform
        • Transition from the previous version to the version 8.3.4
      • Version 8.3.3
        • New functionality and changes
        • New functionality and changes in 1C:Enterprise mode
        • Optimization
        • Changes that affect system behavior
        • Changes that require modification of configuration and administrative settings
        • Renamed objects
        • Mobile platform
        • Transition from the version 8.2 to the version 8.3.3
        • Transition from the previous version to version 8.3.3
      • Version 8.3.2
        • New functions and changes
        • New functions and changes in the 1C:Enterprise mode
        • Optimization
        • Changes altering the system behavior
        • Changes that require changes to the configuration and administrative settings
        • Transition from the previous version to the version 8.3.2
      • Version 8.3.1
        • New functions and changes
        • New functions and changes in 1C:Enterprise mode
        • Optimization
        • Changes altering the system behavior
        • Changes that require changes to the configuration and administrative settings
        • Renamed objects
        • Upgrade from the previous version to version 8.3.1
      • Version 8.2.19
        • New functions and changes
        • New functions and changes in the 1C:Enterprise mode
        • Optimization
        • Changes affecting the system behavior
        • Changes requiring changes to the configuration and administrative settings
        • Transition from the previous version to the version 8.2.19
      • Version 8.2.18
        • New functions and changes
        • Optimization
        • Changes affecting the system behavior
        • Changes requiring changes to the configuration and administrative settings
        • Transition from the previous version to the version 8.2.18
      • Version 8.2.17
        • New functions and changes
        • Changes altering the system behavior
        • Changes that require changes to the configuration and administrative settings
        • Transition from the previous version to the version 8.2.17
      • Version 8.2.16
        • New functions and changes
        • New functions and changes in 1C:Enterprise mode
        • Changes altering the system behavior
        • Changes that require changes to the configuration and administrative settings
        • Transition from the previous version to the version 8.2.16
      • Version 8.2.15
        • New functions and changes
        • New functions and changes in 1C:Enterprise mode
        • Optimization
        • Changes affecting the system behavior
        • Changes requiring changes to the configuration and administrative settings
        • Transition from the previous version to the version 8.2.15
      • Version 8.2.14
        • New functions and changes
        • New functions and changes in the 1C: Enterprise mode
        • Optimization
        • Changes affecting the system behavior
        • Changes that require changes to the configuration and administrative settings
        • Transition from the previous version to the version 8.2.14
      • Version 8.2.13
        • New functions and changes
        • Optimization
        • Changes altering the system behavior
        • Changes requiring configuration changes and administrative settings
        • Transition from the previous version to the version 8.2.13
      • Version 8.2.12
        • New functions and changes
        • New functions and changes in 1C:Enterprise mode
        • Changes affecting the system behavior
        • Changes requiring configuration changes
        • Transition from the previous version to the version 8.2.12
      • Version 8.2.11
        • New functions and changes
        • New functions and changes in 1C:Enterprise mode
        • Optimization
        • Changes affecting the system behavior
        • Changes requiring configuration changes
        • Transition from the previous version to the version 8.2.11
      • Version 8.2.10
        • What's New?
        • Changes affecting the system behavior
        • Changes that require configuration changes
        • Migration from 8.2.9 to 8.2.10
      • Version 8.2.9
        • What's New in Version 8.2 Compared to Version 8.1
          • Managed Application
          • What's New?
            • Server and Database
            • Miscellaneous Objects
            • 1C:Enterprise Script
            • Reports and Data Composition System
            • Designing
            • Other
            • 1C:Enterprise Mode
          • Optimization
          • Changes that Require Configuration Changes or Influence System Behavior
        • Upgrading to Version 8.2 from Versions 8.1 and 8.0
          • Infobase That Is Not Connected to Configuration Repository
            • File-Based Infobase
            • Client/Server Mode Infobase
          • Infobase Connected to Configuration Repository
          • Configuration Dumped to a File
          • Infobase Dumped to a File
          • External Data Processor or External Report
          • Use of Configurations Developed in the Previous 1C:Enterprise Versions
          • Using the Support Files
  • Best practices
    • Access rights
      • How the changing of values of session parameters and functional options impacts performance of data access restrictions mechanism
      • Standard roles
    • Client/server interaction and security issues
      • Optimizing client/server applied solutions for SaaS application delivery model
    • Code conventions
      • 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
        • Writing register records
      • Using 1C:Enterprise script clauses
        • Catching exceptions in 1C:Enterprise script
        • Defining variable value type
        • Event log usage specifics
        • Expression wrapping rules
        • Form module event handlers defined in 1C:Enterprise script
        • General requirements to 1C:Enterprise script clauses
        • Getting object metadata
        • Initializing local variables in advance
        • Limitations to usage of the Goto operator
        • PredefinedValue function usage specifics
        • Using compilation directives
        • Using duplicate script fragments
        • Using global variables in modules
    • Creating and changing metadata objects
      • Application version control
        • Filling configuration properties with the release details
        • General information about application releases
        • Version and revision numbering
      • Data storages
        • Comment attribute of documents
        • Deleting obsolete metadata objects from configurations
        • Delivering data in configuration packages
        • Document posting requirements
        • Generic data storage principles
        • Handling inactive objects
        • Length of configuration object codes and numbers
        • Limitations to usage of composite-type attributes
        • Name, synonym, and comment
        • Reflecting the nature of metadata objects using attributes
        • Self-sufficiency of registers
        • Tooltips and fill checks
        • Using attributes of String type
        • Using predefined items
        • Using the Active property of register records
      • Global configuration requirements
        • Business process route map layout recommendations
        • Code writing standards for easier localization
        • Common module naming rules
        • Configuration initialization
        • General requirements to configurations
        • Metadata object names in configurations
        • Restrictions to renaming metadata objects
        • Shared configuration development workflow
        • Specifics of configuration development for Linux
        • Thick client support in managed applications that run in the client/server mode
        • Time zone differences
        • User settings
        • Using common attributes
        • Using defined types
        • Using functional options
        • Using session parameters
        • Using subsystems
    • Localization guidelines
      • Translation guidelines
    • User interface development (ordinary application)
      • User interaction
        • Application exit confirmation
    • User interface guidelines
      • Capitalization guidelines for user interfaces
      • Parameters that affect user interface language
      • Report options in several languages
  • Developer resources
    • Additional development tools: libraries, data processors, manuals
      • Manuals
        • Requirements to the development of peripheral equipment drivers
    • Administration
      • Backup and restore 1C infobases using SQL Server
      • Choosing server-side hardware for 1C:Enterprise system
      • Data structure in 1C:Enterprise 8
      • How to publish a 1C:Enterprise infobase via HTTPS protocol in IIS
      • Specifics of 1C:Enteprise server administration on Linux
        • Dump generation at unexpected application shutdown on Linux
        • How to change the temporary file directory of a 1С:Enterprise server
        • Kerberos authentification setup example for the Linux version of 1С:Enterprise server
        • Performance degradation in debug mode
      • Specifics of Oracle DBMS usage
        • Oracle database creation for 1C:Enterprise using Oracle Database Configuration Assistant
        • Setting up multilingual collation in Oracle Database Server
        • Working with Oracle Database data files
      • Tips on infobase backup
      • Windows update requirements for 1C:Enterprise 8.3.11
    • Development recommendations
      • 1C:Enterprise script
        • "For each" iterator usage specifics
        • 1C:Enterprise script execution process
        • Handling script errors
        • Infinite recursion
        • Messages displayed to users
        • Nontransactional data reading
        • Passing parameters to procedures and functions by reference and by value
        • Recursion in the script
        • Specifics of reusing return values
        • Storing values in object and form module variables
        • User interruption of module execution
        • Using temporary files in configurations
      • Adapting 1C:Enterprise interfaces for version 8.3.7
      • Applied objects
        • Autonumbering
        • Autonumbering for collaboration
        • Developing a periodic information register structure
        • Direct deletion of objects without deletion marks and reference integrity check
        • Document sequences
        • Predefined data: troubleshooting
        • Tips on choosing between a subordinate catalog and a tabular section
        • Using chart of characteristic types to implement storage of values related to infobase objects
        • Using data types for manipulating database objects
        • Using script tools for working with applied objects
        • Using the DeletionMark field of a database object
        • Using the Posted field and the posting process
        • Using types for manipulating non-object data
        • When to use references, queries, selections, and objects
      • Configuration delivery and support
        • Configuration delivery and support concept
        • Configurations based on several supported vendor configurations
        • Creating distribution and update files
        • Delivery settings and generation of distribution and update files
        • Module merging specifics
        • Recommendations for customizing vendor configurations
        • Specifics of comparing and merging configurations during the update
        • Specifying support options
      • Data composition system
        • Typical balance calculation issues
      • Miscellaneous
        • Avoiding deadlocks
      • Mobile platform
        • Mobile application development
      • 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 field contents
        • Complementing query result by days belonging to a specified period
        • Details on how to use the group inclusion operator
        • Display of reference fields
        • Sample queries for hierarchical catalog operations
        • Selection of all values belonging to a grouping 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
        • Using custom 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
      • Spreadsheet documents
        • Formatting spreadsheet document rows
        • Header and footer usage specifics in spreadsheet documents
        • Optimizing forms that comply with legislation requirements
        • Page-by-page output to a spreadsheet document
      • Values and types
        • Analyzing value types
        • Serialization usage specifics
        • Specifics of database string comparison
        • Specifics of TypeDescription object
        • Specifics of value formatting
        • Understanding "empty" values
        • Using string value presentations
        • Using time periods and points in time
    • Architecture
      • 1C:Enterprise 8 as an open system
      • Concepts of development in 1C:Enterprise 8 environment
      • Database model
      • Development tools
        • 1C:Enterprise script
        • Designer: a workbench for application development
        • Integration tools
        • Query language
        • Updating applied solutions
        • User rights system
    • Common recommendations
      • Application development
        • Style Guide for development
    • Q&A
      • General questions
        • Why is there the thin client if the thick client can work in the managed mode?
        • Why is there the thin client if there is the web client?
    • Utility features (ordinary application mode)
      • Bulk document reposting
  • TechBlog
  • Glossary
  • 1C:DN
  • Knowledge base
  • 1C:Enterprise documentation
  • 1C:Enterprise User Manual
  • Appendix 1. Data composition system expression language
Print
PDA

Appendix 1. Data composition system expression language





The data composition system expression language is intended for recording expressions used in several 1C:Enterprise system features. In particular, it is used in the data composition system for describing custom field expressions.


Literals
String
Number
Date
Boolean
Value
Fields
Parameters
Operations with numbers
  • Unary +
  • Binary +
  • Multiplication
  • Division
  • Remainder
Operations with strings
  • Concatenation (Binary +)
  • LIKE
Comparison operations
  • EQUAL
  • NOT EQUAL
  • LESS THAN
  • MORE THAN
  • LESS OR EQUAL
  • GREATER OR EQUAL
  • IN (for values)
  • IN (for data sets)
  • IS NULL
  • IS NOT NULL
Logical operations
  • NOT
  • AND
  • OR
Aggregate functions
  • SUM
  • COUNT
  • COUNT (DISTINCT)
  • MAX
  • MIN
  • AVG
  • ARRAY
  • VALUETABLE
  • GROUPPROCESSING
  • GROUPBY
  • GETPART
  • ORDER
  • JOINSTRINGS
  • Every
  • Any
  • Stddev_Pop
  • Stddev_Samp
  • Var_Samp
  • Var_Pop
  • Covar_Pop
  • Covar_Samp
  • Corr
  • Regr_Slope
  • Regr_Intercept
  • Regr_Count
  • Regr_R2
  • Regr_AvgX
  • Regr_AvgY
  • Regr_SXX
  • Regr_SYY
  • Regr_SXY
  • Rank
  • ClassificationABC
Other operations
  • CASE operation
  • Rules for comparing two values
  • Operations with NULL value
  • Operation priorities
Functions
  • EVAL
  • EVALEXPRESSION
  • Parameter usage example
Comments
0
Add comment Close
Add comment

You can not add comments until you are not logged in.
Please login or register on our website.

1CN
© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors to our website.
Disclaimers and Limitation of Liability | Terms and Conditions | Site Map