Use the standard retrieval styles
- Last UpdatedFeb 05, 2025
- 2 minute read
The following table describes the standard retrieval styles available in the Historian Client Trend application.
|
Style name |
Description |
|---|---|
|
BestFit-5 |
Best Fit retrieval with one cycle per five pixels. |
|
BestFit-10 |
Best Fit retrieval with one cycle per ten pixels. |
|
BestFit-15 |
Best Fit retrieval with one cycle per 15 pixels. |
|
Cyclic (ActiveFactory 9.1) |
Cyclic retrieval with one cycle per two pixels. |
|
Integral (ad hoc) |
Integral retrieval for queries longer than 15 minutes. Resolution depends on query duration. Best-fit retrieval with one cycle per ten pixels for queries shorter than 15 minutes. |
|
Averages (From Summaries or Ad Hoc) |
Tries to retrieve analog averages from summary tables. If no summary data is available, uses Average retrieval for analog tags and ValueState retrieval for discrete tags. Resolution depends on query duration. |
|
Averages (ad hoc) |
Average retrieval for analog tags and ValueState retrieval for discrete tags. Resolution depends on query duration. |
|
Summary (InSQL 8.0) |
Tries to retrieve analog averages from summary tables for queries longer than 15 minutes. If no summary data is available, uses Cyclic retrieval with one cycle per pixel for queries longer than 8 hours and Delta retrieval for shorter queries. |
|
Counter-20 |
Counter retrieval with one cycle per 20 pixels. |
|
Counter on round periods |
Counter retrieval with cycles at even time periods (one minute, one hour, etc. depending on the resolution). |
|
Time In State (percent) |
ValueState retrieval with percent calculation for queries longer than one minute. Resolution depends on query duration. Full retrieval for shorter queries. |
|
Time In State (Avg) |
ValueState retrieval with average calculation for queries longer than one minute. Resolution depends on query duration. Full retrieval for shorter queries. |
|
RoundTrip (PercentContained) |
RoundTrip retrieval with percentcontained calculation for queries longer than one minute. Resolution depends on query duration. Full retrieval for shorter queries. |
|
RoundTrip (AvgContained) |
RoundTrip retrieval with averagecontained calculation for queries longer than one minute. Resolution depends on query duration. Full retrieval for shorter queries. |
|
MovingAverage (12-5 sec) |
Moving averages for analog tags with 12 values and a resolution of five seconds. Delta retrieval for all other tags. |
|
MovingAverage (30-1 sec) |
Moving averages for analog tags with 30 values and a resolution of one second. Delta retrieval for all other tags. |
|
MovingAverage (10-1 pixel) |
Moving averages for analog tags with 10 values and a resolution of one cycle per pixel. Delta retrieval for all other tags. |