AVEVA™ Historian Retrieval Guide formerly Wonderware Contents
Delta Retrieval - How It Works...................................................................................... 30
Delta Retrieval - Supported Value Parameters............................................................... 30
Delta Retrieval - Query Examples ................................................................................. 31
Delta Retrieval - Initial Values....................................................................................... 34
Delta Retrieval - Handling NULL Values ........................................................................ 34
Full Retrieval..................................................................................................................... 35
Full Retrieval - How It Works ........................................................................................ 36
Full Retrieval - Supported Value Parameters ................................................................. 36
Full Retrieval - Query Example ..................................................................................... 36
Full Retrieval - Initial Values ......................................................................................... 37
Interpolated Retrieval ........................................................................................................ 37
Interpolated Retrieval - How It Works ............................................................................ 37
Interpolated Retrieval - Query Examples ....................................................................... 38
Interpolated Retrieval - Initial and Final Values .............................................................. 41
Interpolated Retrieval - Handling NULL Values .............................................................. 41
Best Fit Retrieval............................................................................................................... 41
Best Fit Retrieval - How It Works .................................................................................. 43
Best Fit Retrieval - Supported Value Parameters ........................................................... 44
Best Fit Retrieval - Query Example ............................................................................... 44
Best Fit Retrieval - Initial and Final Values .................................................................... 45
Best Fit Retrieval - Handling NULL Values .................................................................... 46
Average Retrieval.............................................................................................................. 46
Average Retrieval - How It Works ................................................................................. 47
Average Retrieval - Supported Value Parameters .......................................................... 48
Average Retrieval - Query Examples ............................................................................ 48
Average Retrieval - Initial and Final Values ................................................................... 50
Average Retrieval - Handling NULL Values ................................................................... 50
Minimum Retrieval............................................................................................................. 50
Minimum Retrieval - How It Works ................................................................................ 50
Minimum Retrieval - Supported Value Parameters ......................................................... 51
Minimum Retrieval - Query Examples ........................................................................... 51
Minimum Retrieval - Initial and Final Values .................................................................. 53
Minimum Retrieval - Handling NULL Values and Incomplete Cycles ............................... 53
Maximum Retrieval............................................................................................................ 55
Maximum Retrieval - How It Works ............................................................................... 55
Maximum Retrieval - Supported Value Parameters ........................................................ 56
Maximum Retrieval - Query Examples .......................................................................... 56
Maximum Retrieval - Initial and Final Values ................................................................. 58
Maximum Retrieval - Handling NULL Values and Incomplete Cycles .............................. 58
Integral Retrieval ............................................................................................................... 59
Integral Retrieval - How It Works .................................................................................. 60
Integral Retrieval - Supported Value Parameters ........................................................... 60
Integral Retrieval - Query Example ............................................................................... 60
Integral Retrieval - wwExpression Query Example ......................................................... 61
Integral Retrieval - Initial and Final Values..................................................................... 62
Integral Retrieval - Handling NULL Values .................................................................... 62
Slope Retrieval.................................................................................................................. 62
Slope Retrieval - How It Works ..................................................................................... 63
Slope Retrieval - Supported Value Parameters .............................................................. 63
Slope Retrieval - Query Example .................................................................................. 63
Slope Retrieval - wwExpression Query Example............................................................ 64
Slope Retrieval - Initial and Final Values ....................................................................... 65
Slope Retrieval - Handling NULL Values ....................................................................... 65
Counter Retrieval .............................................................................................................. 65
Counter Retrieval - How It Works.................................................................................. 66