Trend
- Last UpdatedJul 05, 2024
- 2 minute read
The function of this Business Logic Tier (BLT) is to retrieve collection and summary data from the RealTime database (RTDB) collect table and the Historical database TimeSeries or timeline table.
-
The data returned includes the following columns:
-
Time is the collection time in Greenwich Mean Time (GMT) format.
-
Milliseconds is the collection time milliseconds.
-
Value is the summarized or collected value.
-
Status is the traditional data quality.
-
fieldTime is the field time in GMT format.
-
fieldMilliseconds is the field time milliseconds.
-
dqFlag is the position of the active data quality attribute with the highest precedence.
The value of dqFlag is determined by analyzing the attributes that are active in the dqFlags field in the provided table. In instances where the ExtendedDataQualityUnavailable attribute (position 12) is active, the dqFlag will be inferred from the traditional data quality following this conversion table:
|
NameStatus |
dqFlag |
Description |
|---|---|---|
|
A |
5 |
Point was in alarm. |
|
M |
19 |
Value was Manually edited or overriden. |
|
O |
9 |
Point was not actively being polled. |
|
Q |
2 |
The status of the point could not be determined during the value collection. |
|
"." |
0 |
Point was in normal status. No extended data quality attribute active. |
Syntax
Trend <tablename> <tagname> <columnname> <starttime> <endtime> [showFieldTime]
Parameters
|
Name |
Description |
|---|---|
|
tablename |
The name of the RTDB / Historical database table that contains the data to be accessed. This can be any of the following: collect, hour, day, month, year. |
|
tagname |
The name of the point to be viewed. |
|
columnname |
The column of the RTDB / Historical database tables to view. This can be any of the following: value, minimum, maximum, average. If the table name is collect, the only column allowed is the value column. If the table name is not collect, the value column is the instantaneous value of the point. (The value at the top of the hour). |
|
starttime |
The time from which to begin the trend data. This is entered as an integer representing Greenwich Mean Time (GMT) time, which is localized to your time zone. |
|
endtime |
The time at which the trend data stops. This is entered as an integer representing GMT time, which is localized to your time zone. |
|
showFieldTime |
If the table name is collect, enter 1 to display the field timestamp of the collection. Enter 0 or NULL to not display the field timestamp of the collection. |
Example
Trend 'collect', 'analog.0analog.curval', 'value', 1401376140, 1401376320, 1
|
Time |
Milliseconds |
Value |
Status |
fieldTime |
fieldMilliseconds |
dqFlag |
|---|---|---|---|---|---|---|
|
1401376140 |
0 |
2 |
O |
1401376140 |
0 |
2 |
|
1401376200 |
0 |
30 |
A |
1401376200 |
0 |
3 |
|
1401376260 |
0 |
10 |
1401376260 |
0 |
0 |
|
|
1401376320 |
0 |
15 |
M |
1401376320 |
0 |
1 |
(4 rows affected)
Comments
This procedure is primarily used by easy eXtended Operator Station (ezXOS).