Get external data

Overview

Once a database connection has been established, there are different options available for ODBC, SSAS and OData to retrieve data.

Schema

In the Schema menu, you can select the schema of an ODBC data source from which the database tables are to be read.

DB Table / Cube

In the DB table menu you can select the database table, view or cube whose content should be displayed in the widget. To retrieve the content, use the function GETDATA() with no parameter in the Content formula.

DB columns

In DB columns, the database columns can be selected from which the content for the table widget should be retrieved. Click on "Add column" to add an additional column to the list.

For each column, the "..." menu provides options to

• move or delete the db column

• sort up or down by the db column

In addition, the order of the columns can be changed by drag and drop using the drag icon to the left of the db column name.

Menu widget filters

Defines menu widgets, which are used as filter for the database request.

Remarks

• The specified menu widgets must contain a database request as well, including one db column, as described above.

• If is possible to manually enter a widget reference to a menu on another page, in the usual syntax #pageName.menuWidgetName

Aggregate

For ODBC connections, the Aggregate property defines if single datasets should be returned or an aggregation over all numeric database columns.

Top n rows

Specifies the number of rows which should be returned by the database request in Edit mode.

Only in Edit mode

If this property is activated, the top n restriction only applies in Edit mode. In Live mode, all data sets are queried.

Suppress empty rows

For SSAS connections, the Suppress empty rows property specifies if all rows should be returned by the database request, or only the rows which contain values (measures) for the selected db columns.

Number of levels

For hierarchy and hierarchy menu widgets, the property "Number of levels" specifies the number of columns which define the hierarchy. If the setting automatic is selected, the number of non-numeric columns define the hierarchy.