Click or drag to resize

ActionAdapterBaseConnectionString Property

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

Namespace: GSF.TimeSeries.Adapters
Assembly: GSF.TimeSeries (in GSF.TimeSeries.dll) Version: 2.4.181-beta
Syntax
public virtual string ConnectionString { get; set; }
View Source

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='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:
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