ActionAdapterBaseConnectionString Property

Gets or sets key/value pair connection information specific to action adapter.

Definition

Namespace: Gemstone.Timeseries.Adapters
Assembly: Gemstone.Timeseries (in Gemstone.Timeseries.dll) Version: 1.0.128 -- Release Build+e2476c52e94864f123f37e60764c948e49eb89eb
public virtual string ConnectionString { get; set; }

Property Value

String

Implements

IAdapterConnectionString

Remarks

Example connection string using manually defined measurements:
framesPerSecond=30; lagTime=1.0; leadTime=0.5; minimumMeasurementsToUse=-1; useLocalClockAsRealTime=true; allowSortsByArrival=false;
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:
framesPerSecond=30; lagTime=1.0; leadTime=0.5; minimumMeasurementsToUse=-1; useLocalClockAsRealTime=true; allowSortsByArrival=false;
inputMeasurementKeys={FILTER ActiveMeasurements WHERE Company='Gemstone' 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:

NameTypeDescription.
IDNVARCHARMeasurement key formatted as: ArchiveSource:PointID.
PointTagNVARCHARPoint tag of measurement.
AdderFLOATAdder to apply to value, if any (default to 0.0).
MultiplierFLOATMultiplier to apply to value, if any (default to 1.0).

Note that framesPerSecond, lagTime and leadTime are required parameters, all other parameters are optional.

See Also