Knowledge Base

Details:

Download the latest version of the provider proposed in the table at the end of this article and unzip it to execute the msi file.

Follow the instruction given in the ADO.Net Providers installation procedure article to install this provider.

To declare a connection into PcVue, goto General -> Data connections -> Add a SQL connection and select the Data source Built-in providers, then you can choose .NET Framework Data Provider for Influx DB Data provider:

Influx DB Provider declaration part 1

Finally go to the second tab (Built-in) to configure the connection:

Influx DB Provider declaration part 2

Few sample queries:

from(bucket: “ado-bucket”)
|> range(start: -1h)
|> aggregateWindow(every: 5s, fn: mean, createEmpty: false)
|> yield(name: “mean”)

from(bucket: “ado-bucket”)
|> range(start: -1h)
|> filter(fn: (r) => r[“_measurement”] == “airSensors”)
|> pivot(rowKey: [“_time”], columnKey: [“_field”], valueColumn: “_value”)

from(bucket: “ado-bucket”)
|> range(start: 2023-06-29T07:00:00.000Z, stop: 2023-06-29T12:00:00.000Z)
|> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
|> pivot(rowKey: [“_time”], columnKey: [“_field”], valueColumn: “_value”)

from(bucket: “ado-bucket”)
|> range(start: 2023-06-29T07:00:00.000Z, stop: 2023-06-29T09:00:00.000Z)
|> filter(fn: (r) => r[“_measurement”] == “airSensors”)
|> aggregateWindow(every: 5s, fn: last, createEmpty: false)
|> pivot(rowKey: [“_time”], columnKey: [“_field”], valueColumn: “_value”)
|> drop(columns: [“_stop”, “_start”, “_measurement”])

Files attached consist in the: