Skip to content
CtrlDocsSupport Portal

SQL trace data parameter configuration

Reached from Plot Parameters on SQL trace data configuration and Select Parameters on SQL trace data configuration.

Settings

Parameter Name

Type
Text

The name of the parameter used in the SQL query. Must match the parameter name in the SQL query exactly and must be unique within the same query.

Parameter Type

Type
One of a list
Default
Property

Specifies whether the parameter is a property or a placeholder. Default: Property.

  • Property
  • Placeholder

Parameter Context

Type
One of a list
Default
Object

Specifies in what context the property or placeholder should be retrieved from. This can be either from the object itself or from the employee object of the logged in user. Default: Object.

  • Object
  • Employee

Property

Type
M-Files property

Shown when not (Parameter Type is Placeholder).

The M-Files property definition to use for the parameter.

Placeholder

Type
Placeholder text

Shown when Parameter Type is Placeholder.

The placeholder text to use for the parameter. This can be used to dynamically insert values into the SQL query, using the object from the Parameter Context.

Parse Value As

Type
One of a list
Default
String

Specifies how the parameter value should be parsed (e.g., as a string, number, etc.).

  • String
  • Int
  • Double
  • DateTime
  • Boolean

Generated from CtrlPortals 3.26.9.53.