Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Data extension configuration: ExtTrend

Description:
Data extension configuration ExtTrend - An extension for connection to the PmaTrendGroup 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 default value is "trend".

Target object (PmaTrendGroup)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 PmaTrendGroup object.

Macro expression can be used for input, the result must be a NON-LOCALIZED path to Pma object (it is evaluated after starting the application).

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 after starting the application).

This configurator must not contain an empty string.
name for displayingText 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 after starting the application).

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

OrderSpecifies 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 it represents a weight used for evaluating the order.
MinimumLow limit of the variable (minimum).

This configurator sets the initial value of the property Min.

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

MaximumHigh limit of the variable (maximum).

This configurator sets the initial value of the property Max.

The value entered here is used as initialization value for trend viewer (for the PmgTrendViewer 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 Enable saving of variables on change).
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 after starting the application).

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

ColorColor of the variable for displaying 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 viewer (for the PmgTrendViewer object). The value is entered in the following property: tvGraph.Color

Additional parametersAdditional 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 Storage type, for example "dbdt:NUMERIC(12,4);".
name (optional) - (only for Database dBase backups) Specifies the column name. If not defined, then the variable name PmVar 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.
Specifies the bit number to testIf "3 - JavaScript expression" is set, then serves 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 serves for definition of the JavaScript expression itself. The JavaScript expression can have two parameters:
pVal: The value of PmVar.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 the "Data extensions" configurator in the variable of the PmaData object.
 
This data extension registers itself automatically into the PmaTrendGroup object after starting the application. Therefore it is forbidden to create the requested item on the "PmaTrendGroup > Data" page! The corresponding variable for trend may be created 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" page may remain empty. If there are both types of the 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.


History:
Pm8.00.04: Created
PROMOTIC 9.0.4 SCADA system documentation - MICROSYS, spol. s r.o.

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