AdapterBaseConnectionString Property

Gets or sets key/value pair connection information specific to this AdapterBase.

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

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).

See Also