Adapter
|
Example connection string using manually defined measurements:
inputMeasurementKeys={P1:1245;P1:1247;P2:1335};
outputMeasurements={P3:1345,60.0,1.0;P3:1346;P3:1347}
When defined manually, elements in key:
* inputMeasurementKeys are defined as "ArchiveSource:PointID"
* outputMeasurements are defined as "ArchiveSource:PointID,Adder,Multiplier", the adder and multiplier are optional
defaulting to 0.0 and 1.0 respectively.
Example connection string using measurements defined in a DataSource table:
inputMeasurementKeys={FILTER ActiveMeasurements WHERE Company='GSF' AND SignalType='FREQ' ORDER BY ID};
outputMeasurements={FILTER ActiveMeasurements WHERE SignalType IN ('IPHA','VPHA') AND Phase='+'}
Basic filtering syntax is as follows:
{FILTER <TableName> WHERE <Expression> [ORDER BY <SortField>]}
Source tables are expected to have at least the following fields:
Name | Type | Description. |
---|---|---|
ID | NVARCHAR | Measurement key formatted as: ArchiveSource:PointID. |
PointTag | NVARCHAR | Point tag of measurement. |
Adder | FLOAT | Adder to apply to value, if any (default to 0.0). |
Multiplier | FLOAT | Multiplier to apply to value, if any (default to 1.0). |