Execute the Trend stored procedures

This stored procedure is used to retrieve raw trend data, by calling the Trend Business Logic Tier (BLT). The syntax is the same as if the BLT is called directly.

Note: This stored procedure is available only when the RealTime service is running and Hot.

ODBC Syntax

call Trend(<tablename>, <tagnme>, <columnname>, <starttime>, <endtime>, <showFieldTime>, <DTRresolution>)

Example

call Trend('collect', 'analog.0analog.curval', 'value', 1655302566, 1655302671, 1, 0);

time milliseconds value status fieldTime fieldMilliseconds dqFlag

1655302566 709 7 M 1655302566 0 3

1655302648 633 7 O 1655302648 0 6

1655302648 756 89 A 1655302648 696 5

1655302651 443 96 A 1655302651 383 5

1655302661 459 7 1655302661 382 0

1655302671 416 21 1655302671 353 0