The Historian Query Configurator
When connecting to
Wonderware Historian Server through our
Web API, the Historian query is configured using the graphical user interface described below.
You can select all the tags of your server by clicking in the top left corner on All Analog Tags for example like the next screen.
Or if you feel like to select pour preferred Group Tag , just roll down the list and select the group you want.
Then, The TagNames appears in the bottom left pane like below.
Search for a Tagname
You can search for a tagname by clicking on the magnifying glass icon like below
Then, you will be able to enter the searched TagName in the window below
There are optional search options as you can see and the possibility to click on
Then after clicking to the apply button, the result will appear in the list if any matched Tag were found.
Once, you have chosen the Tags you want, you can click on the checkbox to select them. Once the tags are selected it appears like on the screen below
You can unselect a Tag by clicking on its
red cross iconon the top part of the screen
To make a correct Wonderware Historian Query you have to select one tag at least
You can set here all the main
Historian query options.
For better performance, it is advised to avoid very large Historian queries. Please refer to WEB API rows Limitation below
In the panel below you can configure the time setting for the query.
You have the possibility to set the date start here
You can set the time interval here
You can finally set the date end here
By default, the start date and end date parameter are not included in the query.
If you want to include them you can select the
include start date in query or/and
include end date in query option.
If you select both, the interval option will be ignore
Retrieval mode area you can set the
retrieval mode and the query row limit settings, you can configure the cyclic attribute as well.
To display the other retrieval options click on the
Other button like below
The other option display screen appears like below
The Phantom Cycle : Do not include boundary values feature is currently not supported
Now, when you click Get Data, you will get into the data design view window.
WEB API rows Limitation
In order to limit performance issues for huge Historian queries, a limit of
10000results is set on the API.
When a Historian query returns more than 10000 results, the API only returns the first
10000. To indicate that data is truncated, the field
IsResultTruncated is set to 1 like below
We can see here the
rows retrieved field value is equal to
10000 which is the
web api limit, and the
IsResultTruncated field value is equal to 1.(value equals to 0 when not truncated)