Array Formula Parameters
Parameter | Description |
---|---|
pArchiveNameMask
| A search mask you can use to browse the archivers. Use standard Windows wildcard characters. |
pArraySize
| The number of cells that the array spans. |
pCalculationMode
| The type of calculation mode. See the ?Calculation Modes ? section in the Getting Started with Historian guide for a complete list. |
pCollector
| The collector or collector mask that you want to query. |
pCollectorNameMask
| A search mask for browsing collectors. Use standard Windows wildcard characters. |
pDescriptionMask
| A search mask for browsing tag descriptions. Use standard Windows wildcard characters. |
pDirection
| The direction (forward or backward from the start time) of data sampling from the archive. |
pEndTime
| The end time used to refine your query. |
pFilterComparisonMode
| The type of comparison to be made on the filter comparison value:
|
pFilterComparisonValue
| The value to compare the filter tag with when applying the appropriate filter to the DataRecordset query (to determine the appropriate filter times). |
pFilterExpression
|
An expression that includes multiple filter conditions. The type of conditions used are:
Filter Expression can be used instead of |
pFilterMode | The type of time filter:
The For example, |
pFilterTag | The single tagname used when applying the filter criteria. |
pNumberOfSamples | Number of samples from the archive to retrieve. Samples will be evenly spaced within the time range defined by start time and end time for most sampling modes. For the |
pRowCol | The sorting criteria used: 0 for Columns and 1 for Rows. |
pSamplingInterval | For non-raw sampled data, this column represents a positive integer for the time interval (in milliseconds) between returned samples. |
pSamplingMode | The type of sampling mode used by the query. See the ?Sampling Modes ? section in the Getting Started with Historian guide for a complete list. |
pSearchText | The text or mask that you want to search for in the message. |
pServer | Name of the server from which you are retrieving data. If you are running Excel on the same server that you are retrieving data from, you do not have to enter a string, as the default server is used. |
pSort | The sorting criteria used for the rows or columns: 0 for Descending and 1 for Ascending. |
|
The start time used to refine your query. |
pTagMask | A search mask for browsing tagnames. Use standard Windows wildcard characters. |
pTagName | The tagname or tagname mask that you want to query. |
pTopic |
The message topic:
|
Parameters() | Output display of the array formula. This field can include be one or more parameters. |