Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Data extension configuration: ExtTrend

Description:
Data extension configuration ExtTrend - An extension for connection to the PmTrend object
Configuration items:
Data extension identifierSystem text (without spaces and diacritics). It is used for unambiguous identification of data extension in data item (e.g. for Extension property).

The preset value is "trend".

Target object (PmTrend) Path to the target object of appropriate type, in which the data item must be registered. The object can also be selected by the button on the right. This selection allows to modify the trend type, saving period and another parameters defined in the PmTrend object.

Macro expression can be used for input, the result must bea NON-LOCALIZED path to PROMOTIC object (it is evaluated while the application is launching).

Trend identifierTrend identifier and variable (column) name in the trend database table. Caution! The variable name must comply with the limitation of corresponding database table column name (see Storage type).

Macro expression can be used for input, the result must be a NON-LOCALIZED SYSTEM text (it is evaluated while the application is launching).

This configurator must not contain an empty string.
Display nameText that can be shown as the name of the item in the trend viewer.

This configurator sets the initial value of the property DisplayName.

Macro expression can be used for input ($.text ..) (it is evaluated while the application is launching).

The value entered here is used as initialization value for trend views (for TrendsView object). The value is entered in the following property: tvTrend.Name

OrderDefines the order (placement) of variable (column) in the trend database table. The order is defined upwardly according to order value (weight). The order value is represented by a decimal number (>= 0), allowing to insert new variable between any two other variables. The value does not represent the specific variable index in the table, but more likely a weight used for evaluating the order.
MinimumLow limit of the variable (its minimum).

This configurator sets the initial value of the property Min.

The value entered here is used as initialization value for trend views (for TrendsView object). The value is entered in the following property: tvTrend.ValueMin

MaximumHigh limit of the variable (its maximum).

This configurator sets the initial value of the property Max.

The value entered here is used as initialization value for trend views (for TrendsView object). The value is entered in the following property: tvTrend.ValueMax

Dead bandValue insensitivity range. It is valid only if the optimalized value storage is enabled, see: Save variable changes only.
UnitPhysical unit of the variable (for example "kWh").

This configurator sets the initial value of the property Unit.

Macro expression can be used for input ($.text ..) (it is evaluated while the application is launching).

The value entered here is used as initialization value for trend views (for TrendsView object). The value is entered in the following property: tvTrend.Unit

ColorColor of the variable to be displayed in the trend viewer.

This configurator sets the initial value of the property Color.

The value entered here is used as initialization value for trend views (for TrendsView object). The value is entered in the following property: tvGraph.Color

Additional parametersAdditional parameters for saving the trend value. Allow to define the database data type or table column name.
dbdt (optional) - Database column data type. For specific database data types see Storage type, for example "dbdt:NUMERIC(12,4);".
name (optional) - (only for Database dBase backups) Defines the column name. If not defined, then the variable name Var or ExtTrend is used as column name.
Value typeMethod 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.
Specify the bit number to testIf "3 - JavaScript expression" is set, then it is used for specifying the particular bit index. The particular bit is identified by the order, so the lowest bit is numbered 0.
JavaScript expressionIf "3 - JavaScript expression" is set then it is used for definition of the JavaScript expression itself. The JavaScript expression can have two parameters:
pVal: The value of Var.Value variable for simple usage in the expression.
pDE: Reference to data extension object (for obtaining other values from data extension or from variable).
Note:
This configuration window can be opened from Data extensions configurator in the data item of the PmData object.
 
This data extension registers itself automatically into the PmTrend object after application launch. Therefore it is forbidden to create the requested item at the page PmTrend > Data! The corresponding variable for trend may be created directly in the PmTrend object as a Var object, or it can be registered as a data extension (ExtTrend).

If all items in the PmTrend object are of the "Data extension" type, then the page PmTrend > Data may remain empty. If there are both types of the items present in the PmTrend object, then in the database table the Var type items will be entered first followed by the "Data extension" items.

© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice