Configuration to get data from database

GPA Products openPDC
32

You can’t do it, because that would require concentration which is not supported by the ADO adapter. The expectation is that you’d handle concentration after you have archived your data. Here’s a simple example, based on various assumptions, that uses SQL JOINs to concentrate the TimeSeriesMeasurement table.

WITH tsm AS
(
    SELECT
        SignalType.Acronym AS SignalType,
        TimeSeriesMeasurement.Timestamp,
        TimeSeriesMeasurement.Value
    FROM
        TimeSeriesMeasurement JOIN
        Measurement ON TimeSeriesMeasurement.SignalID = Measurement.SignalID JOIN
        SignalType ON Measurement.SignalTypeID = SignalType.ID
)
SELECT
    FREQ.Timestamp,
    VPHA.Value AS VPhase,
    IPHA.Value AS APhase,
    FREQ.Value AS Frequencie
FROM
    tsm FREQ JOIN
    tsm VPHA ON FREQ.Timestamp = VPHA.Timestamp JOIN
    tsm IPHA ON FREQ.Timestamp = IPHA.Timestamp
WHERE
    FREQ.SignalType = 'FREQ' AND
    VPHA.SignalType = 'VPHA' AND
    IPHA.SignalType = 'IPHA'
ORDER BY FREQ.Timestamp