Interpolated retrieval - query 1

Two analog tags and a discrete tag are retrieved from the History table, using linear interpolation. The start and end times are offset to show interpolation of the SysTimeMin tag. The data points at all cycle boundaries are interpolated for the two analog tags, while the values returned for the discrete tag are stair-stepped.

SELECT DateTime, TagName, Value, wwInterpolationType FROM History

WHERE TagName IN ('SysTimeMin', 'ReactTemp', 'SysPulse')

AND DateTime >= '2005-04-11 12:02:30'

AND DateTime <= '2005-04-11 12:06:30'

AND wwRetrievalMode = 'Interpolated'

AND wwInterpolationType = 'Linear'

AND wwResolution = 60000

The results are: