Important: You do not have the latest version of Historian! You are missing out on the newest capabilities and enhanced security. For information on all the latest features, see the Historian product page. For more information on upgrades, contact your GE Digital sales agent or e-mail GE Digital Sales Support. For the most up-to-date documentation, go here.
Filtered Queries in the Excel Add-in Example
This example shows how a filtered data query returns specific data from the Historian archive. The example uses two tags: batchid and ramp. The batchid tag is updated before a new batch is produced with the new batch's ID. The ramp tag contains raw data sent by a device in the process. In this example, it is requested that Historian return data samples at ten second intervals for the ramp tag during the period that the batchid tag is set to B1.
A standard query in Historian for the ramp tag's values between 08:00 and 08:01, at ten second intervals, would look like this:
Historian
