ChartOfAccountsExtDimensionTypes.<Chart of Accounts name>.GroupBy

Syntax:

GroupBy(<GroupingColumns>, <TotalingColumns>)

Parameters:

<GroupingColumns> (required)

Type: String.
The names of columns (separated by commas), by which you want to group table box lines.

<TotalingColumns> (optional)

Type: String.
The names of columns (separated by commas), by which you want to sum values of table box lines.

Description:

Collapses the tabular section by specified grouping columns. Rows with matching values in columns specified by the first parameter are combined into one row. Values from these rows stored in the columns specified by the second parameter are accumulated.
Important: Both column lists must cover all of the tabular section. Column lists must not overlap.

Availability:

Server, thick client, external connection.

Note:

This method is implemented for compatibility with tabular sections and is meaningless for the given object.
The method can be used only when the tabular section is obtained from an object's property. If the tabular section is obtained from a reference property (or selection property), using this method would cause a runtime error.

Example:

Content.GroupBy("Nomenclaturee", "Count, Sum, Total");

    

1C:Enterprise Developer's Community