Dataset SQL configuration

An SQL query against a named SQL data source as a dataset source.

Reached from SQL on Dataset source configuration.

Settings

Data source nameRequired

Type

Text

The name of an SQL data source defined under the top-level Data Sources configuration.

Query

Type

Text

The SQL SELECT used to build the dataset. You can scope it to the current object with @subjectId / @subjectType, the user with @currentUserId, and any parameters defined below.

Parameters

Type

List of Dataset SQL parameter

Optional query parameters bound from the current object's properties.

Settings on each entry — 2 of them

Id column

Type

Text

Optional. The result column holding the M-Files object ID, so rows link to their object. Hidden from the displayed columns.

Type column

Type

Text

Optional. The result column holding the M-Files object type. Required together with the Id column for click-through. Hidden from the displayed columns.

Title column

Type

Text

Optional. The result column holding the object's title for the link text.

Generated from CtrlPortals 3.26.9.53.