Inserting a Table or Loop 

Use

You want to include a table () from the interface on the left of the screen and define the loop that selects the table data. You have two options here:

Inserting a Table Node with Drag&Drop

Use Drag&Drop to move the required table from the interface to an existing node in the context. Proceed as described under 5. below.

Inserting a Table Node Using the Context Menu

...

       1.      Select an existing node in the context, under which you want to create a table/loop node.

       2.      In the context menu of the node, choose Create ® Loop.

To display the context menu of the node, click the secondary mouse button.

       3.      In the Create Loop dialog box, enter a table name.

Use the F4 help to display a list of all tables used in the interface.

       4.      Choose Enter

       5.      The system creates a table node under the selected node. The node is fully expanded so that you can see the individual fields of the table. In the window under the context, the system displays the properties of this node.

○     If you are using a migrated Smart Form as a form, specify the assignment type under Output Behavior and also the work area of the table. For more information, see the documentation for Smart Forms, under Reading Internal Tables.

○     If required, restrict the table range that you want to read by setting the input fields From Row and To Row.

○     Under Status, you can set the table node as active or inactive.

You can set individual data nodes in the table as Active or Inactive in the context menu. Only active nodes are sent to the layout in the Form Builder.

       6.      Under Conditions, enter the prerequisites that need to be met before the table is processed at runtime and displayed in the form.

You can also specify conditions for individual data nodes in the table.

       7.      You can use WHERE conditions to select only parts of the data from the table at runtime.

       8.      Under Control Levels, enter one or more data fields from the table that you want to use to group information in the output. When you choose this option, the context tree is changed. The grouping is indicated by the selected fields being placed before all other fields of the table.

You can choose between ascending and descending sorting. However, this is only active if you do not set the Already Sorted flag under Properties.

Data nodes that are defined as part of a structure within the table cannot be specified as a control level.

Result

You have created a complete table node. When you expand the node, you can see the individual fields of the table. These have been generated, which means they are flagged with the  icon.

In the layout in the Form Builder, you can insert the table node in the form. At runtime, the data is selected according to your settings.