Data extension ExtTrend - configuration window

Description:

Data extension configuration ExtTrend - Data extension for connection to the PmaTrendGroup object.

This configuration window can be opened from the "Data extensions" configurator in the variable of the PmaData object.

Configurators:

Data extension identifier	System text. Must not contain diacritics, spaces and special characters. It is used for unambiguous identification of data extension in data item (e.g. in the Extension method). The default value is "trend".
Target object (PmaTrendGroup)	Path to the target object of appropriate type, in which the data variable must be registered. The object can be selected also by the button on the right. This selection allows to modify the trend type, saving period and another parameters defined in the PmaTrendGroup object. Macro expression can be used for input, the result must be a NON-LOCALIZED path to the Pma object (it is evaluated after the application is launched).
Trend identifier	Trend identifier and variable (column) name in the trend database table. Caution! The variable name must comply with the limitations of corresponding database table column name (see the "Storage type" configurator). For the Database dBase backups the maximum name length is 11 characters. Macro expression can be used for input, the result must be a NON-LOCALIZED SYSTEM text (it is evaluated after the application is launched). This configurator must not contain an empty string.
Order	Specifies the order (placement) of the variable (of the column) in the trend database table. The order is defined ascending according to order value (weight). The order value is represented by a decimal number (>= 0), allows to insert new variable between any two other variables. The value does not represent the specific variable index in the table, but more likely it represents a weight used for evaluating the order.
Dead band	Variable insensitivity range. It is valid only if the optimalized value storage is enabled (see Enable saving of variables on change).
Additional parameters	Additional parameters for saving the trend variable. Allow to define the database data type or table column name. dbdt (optional) - Database column data type. For specific database data types see the "Storage type" configurator, for example "dbdt:NUMERIC(12,4);". name (optional) - (Only for Database dBase backups) Specifies the column name. The maximum name length is 11 characters. If not defined, then the PmVar variable name or name in the ExtTrend object is used as column name.
Value type	Method for obtaining value for evaluation (testing): 0 - whole value - The whole value is used. 1 - defined bit - Value of specified bit is used. 2 - defined bit - negated - A negated value of defined bit is used. 3 - JavaScript expression - Value defined by JavaScript expression is used.
Specifies the bit number for testing	If set "3 - JavaScript expression", then serves for specifying the particular bit index. The particular bit is identified by the order, so the lowest bit is numbered 0.
JavaScript expression	If set "3 - JavaScript expression", then it serves for specifying of the JavaScript expression itself. The JavaScript expression can have two parameters: pVal: The value of the PmVar.Value property for simple usage in the expression. pDE: Reference to data extension object (for obtaining other values from data extension or from the variable). pVar: Reference to the PmVar object of data extension.
Default values for the trend viewer
Displayed trend name	Text that can be shown as the name of the item in the trend viewer. This configurator sets the initial value of the DisplayName property. Macro expression can be used for input ($.text ..) (it is evaluated after the application is launched). The value entered here serves as initialization value for the trend viewer (for the PmgTrendViewer object). This value is entered in the property: tvTrend.Name
Minimum	Lower limit of the variable (minimum). This configurator sets the initial value of the Min property. The value entered here serves as initialization value for the trend viewer (for the PmgTrendViewer object). This value is entered in the property: tvTrend.ValueMin
Maximum	Upper limit of the variable (maximum). This configurator sets the initial value of the Max property. The value entered here serves as initialization value for the trend viewer (for the PmgTrendViewer object). This value is entered in the property: tvTrend.ValueMax
Unit	Physical unit of the variable (for example "kWh"). This configurator sets the initial value of the Unit property. Macro expression can be used for input ($.text ..) (it is evaluated after the application is launched). The value entered here serves as initialization value for the trend viewer (for the PmgTrendViewer object). This value is entered in the property: tvTrend.Unit
Color	Color of the variable for displaying in the trend viewer. This configurator sets the initial value of the Color property. The value entered here serves as initialization value for the trend viewer (for the PmgTrendViewer object). This value is entered in the property: tvGraph.Color

Note:

This data extension registers itself automatically into the PmaTrendGroup object after the application is launched. Therefore it is forbidden to create the requested item on the "PmaTrendGroup > Data" tab! The corresponding variable for trend can be created either directly in the PmaTrendGroup object as a PmVar object, or it can be registered as a data extension (ExtTrend).
If all items for the PmaTrendGroup object are of the "Data extension" type, then the "PmaTrendGroup > Data" tab may remain empty.
If there are both types of items present in the PmaTrendGroup object, then in the database table the PmVar type items will be entered first followed by the "Data extension" items.