View table properties - Data

Data

Application / Data group

Select the data source here.

Filter

Opens a dialog where a filter can be defined.

Display dependent rows

This setting can only be selected if you have chosen a subordinate data group as the data source. This setting will only display the data records that are in a parent-child relationship with the currently selected data record.

Columns

"Column" column

In this column, the titles of the data fields, which are integrated as table columns, are listed.

"Data field/Value" column

Here, the data type of the data fields, which are integrated as table columns, are listed.

Add column

Opens a menu with the following options.

• Button

  This menu item allows any number of buttons to be added to each table row. Each button is displayed in its own table column.

• Data Field

  Opens a dialog where data fields can be selected.

• Calculations

  This menu item allows calculations to be performed in an area underneath the view table, such as to show the total amount in a column.

• Static text

  This menu item adds a column where static text can be entered.

Remove column

Deletes the selected table column from the list.

Edit column

Opens the properties dialog for the corresponding table column.

Edit total calculation

Opens a dialog for creating a new calculation. Calculations can be performed in an area underneath the view table, such as to show the total amount in a column.

With the arrow buttons, the order of the columns can be changed as desired. The higher a field is positioned in the list, the further left the column will be shown in the table.

Control type

Control type If a table column is selected, you can select from the possible control types here. You can define the target destination for buttons.

The "Dynamic View" control type can be selected for data fields of the type string, text, integer, double, datetime or Boolean (i.e. for all data types except the file data type) if the data field is from the main data group that provides the data for the view table.

The control type "Multiple selection" or "Multiple selection 2.0" must be selected for data fields with type string, text, integer, double, datetime or boolean (i.e. for all data types except file data type), if the data field is from a child data group of the main data group providing the data for the view table. For child data fields of the file data type, the control type "Multiple selection" or "Multiple selection 2.0" can be selected, but it is not mandatory.

Sort

Sorting

Opens a dialog where the table's sorting can be defined.

API for tables

API for tables A special API has been developed to be used in Velocity. This API can be used to processed, display and scroll through defined tables (such as from the hidden area). The documentation for the API object is available here.

Preselection

Preselections are used to group data. A preselection can be created from the context menu of the view table or via the Edit menu / Preselection / Create preselection when the table is selected on the workspace.

You can use the tabs in the footer of the table to switch between Table and Preselection.

In the properties dialog, a field can be selected that will be used to group the data records in the table. In the database, a "Distinct" query will be defined to filter the data records. You can define as many preselections as you would like for a table. The order of the preselections can be adjusted via the Edit menu / Preselection / Move left or Move right respectively.