Trendview

This stored procedure is used to retrieve trend data with formatted timestamps suitable for displaying in a report, by calling the Trendview Business Logic Tier (BLT). The syntax is the same as if the BLT is called directly.

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

call Trendview('collect', 'analog.0analog.curval', 'value', '10/1/2013 15:00', '10/1/2013 16:00', 0);

time milliseconds status timestamp value

10/1/2013 15:00:00 0 M 10/1/2013 15:00:00.000 100

10/1/2013 15:01:00 0 M 10/1/2013 15:01:00.000 100

…

10/1/2013 15:59:00 0 M 10/1/2013 15:59:00.000 100

10/1/2013 16:00:00 0 M 10/1/2013 16:00:00.000 100