COM - dpGetPeriodIntervall()

Query of data point attributes over a specific period. This is a specific function for the Excel report.

Synopsis

dpGetPeriodIntervall (date dtFrom, date dtTo, long iIntervall, long IntUnit, dyn_variant avDpNames, dyn_variant avStatFct, dyn_variant &avValues, dyn_date &adTime);

Parameter

Parameter Description
dtFrom Start time
dtTo End time
iInterval Describes a period
IntUnit Describes a period (is already defined as: 1 = second, 2 = minute, 3 = hour, 4 = week, 5 = day, 6 = month, 7 = year.
avDpNames Data point name
avStatFct Statistical function
avValues Values
adTime Times

Description

The arrays are defined starting with 0. The element 0 is ignored. For this reason, only valid data from 1 is used in a for statement. The result is a two-dimensional array that contains at least one empty variant at each point in time. If there are several values in an interval step, the result is formed taking into account the statistical function of the avStatFct array.

Assignment

COM - specific function for the Excel report.