Columns tab options

Use the Columns tab to select the columns that you want to include in the query results.

The column options are:

• Tag Name: The name of the tag within the AVEVA Historian server. If the data values are coming from Application Server, the attribute reference is shown as the tag name. You can also choose to show the hierarchical name along with the attribute reference. For more information see, ArchestrA Naming Conventions.

• Description: The description of the tag.

• SourceTag: The source tag of the tag.

• SourceServer: The source server of the tag.

• StartDateTime: The start time of the retrieval cycle.

• EndDateTime: The end time of the retrieval cycle.

• OPCQuality: The quality value received from the data source.

• PercentGood: The percentage of rows with good quality in relation to the total number of rows in the retrieval cycle.

• First: First value within the retrieval cycle or the most recent value prior to the cycle.

• FirstDateTime: The time stamp associated with the first value of the retrieval cycle.

• Last: The last value within the retrieval cycle or the most recent value prior to the cycle.

• LastDateTime: The time stamp associated with the Last value, which can be earlier than the StartDateTime if this is the initial value for the retrieval cycle.

• Minimum: The minimum value that occurred within the retrieval cycle.

• MinDateTime: The time stamp associated with the minimum value.

• Maximum: The maximum value that occurred within the retrieval cycle.

• MaxDateTime: The time stamp associated with the maximum value.

• Average: The time weighted average value of the retrieval cycle.

• Standard Deviation: The time weighted standard deviation value of the retrieval cycle.

• Integral: The area under the value curve of the retrieval cycle.

• ValueCount: The number of values contributing to the summary.

• wwCycleCount: The number of retrieval cycles (sub-intervals) for the specified time period. For more information, see Cycle Count (X Values over Equal Time Intervals) (wwCycleCount).

• wwResolution: The sampling rate, in milliseconds, for retrieving the data in cyclic mode. For more information, see "Resolution (Values Spaced Every X ms) (wwResolution).

• wwTimeZone: The time zone for retrieval is specified.

• wwRetrievalMode: The processing of retrieved data is specified before it is returned to the client. For more information, see Understanding Retrieval Modes.

• wwVersion: The version of data to be used if the original data value is changed.For more information, see History Version (wwVersion).