We currently testing the VTScada REST SQL Query function against historian data.
We are querying two tags:
MORESCO-1\CalcTags\Lumbo\LumF1\SustainedUnsched\Cust-Min:Value
MORESCO-1\CalcTags\Lumbo\LumF1\SustainedUnsched\Cust-Aff:Value
using the following SQL query:
SELECT timestamp,
'MORESCO-1\CalcTags\Lumbo\LumF1\SustainedUnsched\Cust-Min:Value' AS CustMin,
'MORESCO-1\CalcTags\Lumbo\LumF1\SustainedUnsched\Cust-Aff:Value' AS CustAff
FROM History
WHERE timestamp BETWEEN '2026-05-28' AND '2026-06-27'
ORDER BY timestamp ASCENDING
The query result returns separate historian records for each tag. Since the two tag updates occur approximately 1 ms apart and timestamp different, VTScada stores them as individual historian events, resulting in output similar to attached query result.
We would like to know whether can we combine or there is a method to combine these into a single record like below? Could you please guide me how to do?
We currently testing the VTScada REST SQL Query function against historian data.
We are querying two tags:
MORESCO-1\CalcTags\Lumbo\LumF1\SustainedUnsched\Cust-Min:Value
MORESCO-1\CalcTags\Lumbo\LumF1\SustainedUnsched\Cust-Aff:Value
using the following SQL query:
SELECT timestamp,
'MORESCO-1\CalcTags\Lumbo\LumF1\SustainedUnsched\Cust-Min:Value' AS CustMin,
'MORESCO-1\CalcTags\Lumbo\LumF1\SustainedUnsched\Cust-Aff:Value' AS CustAff
FROM History
WHERE timestamp BETWEEN '2026-05-28' AND '2026-06-27'
ORDER BY timestamp ASCENDING
The query result returns separate historian records for each tag. Since the two tag updates occur approximately 1 ms apart and timestamp different, VTScada stores them as individual historian events, resulting in output similar to attached query result.
We would like to know whether can we combine or there is a method to combine these into a single record like below? Could you please guide me how to do?
