Filtered Queries in the Excel Add-in Example
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:
| Time Stamp | Value | Data Quality |
|---|---|---|
| 07/30/2003 08:00:10 | 16 | Good |
| 07/30/2003 08:00:20 | 22 | Good |
| 07/30/2003 08:00:30 | 34 | Good |
| 07/30/2003 08:00:40 | 46 | Good |
| 07/30/2003 08:00:50 | 50 | Good |
| 07/30/2003 08:01:00 | 55 | Good |
If we perform a query against the
batchid tag for the same time interval, we would receive the following results:| Time Stamp | Value | Data Quality |
|---|---|---|
| 07/30/2003 08:00:00 | B0 | Good |
| 07/30/2003 08:00:20 | B1 | Good |
| 07/30/2003 08:00:45 | B2 | Good |