Editing external data source tables

Use the editor window to edit external data source tables.

Data

This tab is intended for generating external data source table field descriptions.

In the Table type field, specify the data source table type: table or expression.

In the Name in the data source property, specify the table name in the data source.

For expressions, in the Expression in the data source field, specify the expression in the data source in the source language. To specify the expression, click the selection button.

Data type

Object data. Select this option for tables that contain object data, for example, tables that store lists or document data. You can specify a presentation field and object forms for object data.
Nonobject data. Select this option for all other tables. You can specify a record form for nonobject data.

The Key fields property contains the table key fields. To specify the fields, click the selection button. In the form that is opened, specify the list of key fields and their order.

If you specify a single key field, the Table data type property is set to Object data. If you specify multiple fields, the Table data type property is set to Nonobject data and selection of additional metadata object characteristics becomes unavailable. You can use object data tables as field types for other tables.

The Presentation field property contains the field that is used as table row presentation.

Clicking the Presentation handlers button opens the manager module and positions the cursor to the PresentationFieldsGetProcessing() handler. If the module does not include PresentationFieldsGetProcessing() and PresentationGetProcessing() handlers, they are created automatically.

The list at the bottom displays the structure of the fields that are described in the external data source table. You can add or remove fields, order them, and edit their properties. For each field that you add, in the property palette, in the Name in data source property, specify the linked external data source table field.

When you delete a table, the field types are checked for references to the table. If references to the table are found, a warning is displayed, and the list of referencing fields is displayed in the message window.

Hierarchy

This tab is intended for specifying the external data source table hierarchy. Fields on this tab are available for object tables only. The data composition system uses data specified on this tab for generating hierarchical groupings and checking hierarchy conditions. In the query language, this data is utilized by the IN HIERARCHY operator.

In the Parent field property, specify the name of the table that stores the parent.

In the Missing parent descriptor property, select the missing parent value type. Available options are NULL and Set value.

In the Missing parent descriptor value property, specify the table key type or NULL. This value is used for checking whether the parent record is available.

This tab is intended for specifying configuration objects that can be generated based on the table and configuration objects that can serve as a basis for generating the table.

The Read-only check box shows whether the table is read-only.

In the Transaction isolation level box, select the transaction isolation level for the table.

In the Data version field box, select the field that contains the table row version.

In the Data lock fields box, select fields that will be used in managed locks.