Table tab

Use this tab to maintain the overall data of the InContext model.
General Information
Table
The table name and description.

To edit or view the session in the Session Editor, click the hyperlink.

Dependent InContext Models
This link shows the dependent Table and Session Models in separate view below the editor. You can use that view to refactor dependent models.
See Dependent InContext Models view.
(Re)generate
Click this link to (re)generate the InContext model.
Alternatively, you can (re)generate the model through the (Re)generate Implementation Model (tticm1210m000) session.
Drillback
Drillback session
The session that is started when the business object is referenced and must be displayed.

To edit or view the session in the Session Editor, click the hyperlink.

Click Browse to view all sessions where the main table is the same as the table of the current model.

From Enterprise Server version 10.3 you can define the session code through a hook. To add a hook, click the Hook link. To remove a hook, clear the hook code. The hook must return a String.

Mode
Indicates whether the drillback session will start as single or multi occurrence session, assuming that the session supports the selected mode. Default value is Single Occ.

From Enterprise Server version 10.3 you can define the mode through a hook. This hook must return either SINGLE_OCC or MULTI_OCC.

Index
The index the drillback session will start with.

From Enterprise Server version 10.3 you can define the index through a hook. This hook must return a Long.

If the session code is specified using a hook, the index must also be specified through a hook.

If you leave this field blank, the default index, 1, is used.

Referenced Tables
Referenced Tables grid
The grid shows all referenced tables from the model. If a hidden element is present in the model and has the value 'true', a strikethrough font is used. The descriptions are read from the server. If the same table occurs multiple times as referenced table, the sequence number element is used to make the descriptions unique.

The 'hidden' check box toggles the 'hidden' element of the referenced table.

The grid synchronizes with the Table Reference section.

To create a row in the grid and add a referenced table, click Add. This field supports code completion. The table is validated and the description is added. These default settings are generated for the table reference:

  • Reference type: where
  • Mandatory: false
  • Field mapping: all primary key fields of the referenced table that are also present as fields in the current model table.

To remove a table from the grid, right-click the table and select Remove. This is only possible for referenced tables that are not present in the active Reference Model.

Include Hook/Declaration Hook/Function Hook
Click these links to open the corresponding hooks in the source viewer in the Hook section.
Table Reference
Type
The reference type.

The TableRead Hook hyperlink is only active in case of Type 'hook'. If the Type is changed, the Mappings are generated following the rules.

Mandatory
If this check box is selected, the referenced table must be present.
Field Mapping grid
This mapping defines how the current table is related to the referenced table. The From fields must exist in the current table. The To fields must exist in the referenced table.

To create a row in the grid and add a mapping, click Add. Code completion is possible on both, From and To fields.

To remove a mapping from the grid, right-click the mapping and select Remove.

Use the Up and Down buttons to change the position of the mapping, although this does not have any impact.

Hook
Source viewer panel
Use this viewer to edit the selected hook.

This editor supports all LN Studio Script Editor features, such as code completion, text hover tool-tips, open declaration, and syntax highlighting.

See Script Editor.

In the hooks, you can use all table fields from the current table and all referenced tables.

Click the Previous hyperlink to move to the previous hook in the model.

Click Next to move to the next hook in the model.

Click Compile to generate a source with the three generic hooks (Include, Declaration and Function) and a wrapper around the current hook. The Include and Declaration hooks themselves are compiled solely.