QuerySchemaFields.Add

Syntax variant: From the string

Syntax:

Add(<Expression>, <Column>, <NestedTableColumn>)

Parameters:

<Expression> (required)

Type: String.
String based on which the expression will be created.

<Column> (optional)

Type: Number.
Column index where added field should be placed.

<NestedTableColumn> (optional)

Type: Number.
When a field is added from a nested table, the paramters specifies the column, to which new nested table is placed. If the nested table already exists, the parameter is ignored.

Description of method variant:

It creates and adds a new expression from the string transferred.

Syntax variant: From an available field

Syntax:

Add(<AvailableField>, <Column>, <NestedTableColumn>)

Parameters:

<AvailableField> (required)

Type: QuerySchemaAvailableField.
Available field from which a query schema expression will be created.

<Column> (optional)

Type: Number.
Column index where added field should be placed.

<NestedTableColumn> (optional)

Type: Number.
When a field is added from a nested table, the paramters specifies the column, to which new nested table is placed. If the nested table already exists, the parameter is ignored.

Description of method variant:

It creates and adds a new expression from an available field of the query schema.

Syntax variant: From the available nested table

Syntax:

Add(<AvailableNestedTable>)

Parameters:

<AvailableNestedTable> (required)

Type: QuerySchemaAvailableNestedTable.
Available nested field from which a nested table of the query schema will be created.

Description of method variant:

It creates and adds a nested table of the query schema from the available nested table.

Returned value:

Type: QuerySchemaExpression;QuerySchemaNestedTable.

Description:

It adds a new item to the collection. If the type of such new item does not match the given collection, the item will not be added.

Availability:

Server, thick client, external connection.

    

1C:Enterprise Developer's Community