代码拉取完成,页面将自动刷新
influxdb删除数据:
influx delete -org windb --bucket plc \
--start 1970-01-01T00:00:00Z \
--stop 2050-01-01T00:00:00Z \
--predicate '_measurement="opcua"' \
--host http://localhost:8086 \
--token 3v3lz9sRWqAzo4zm7w4ujCNRAlsgdPDp8INbgwey6iPOymP9J0hnD02Wb8dznadWMzOwjpkVJ8TfAR9yrnTPEw==
localhost: 3v3lz9sRWqAzo4zm7w4ujCNRAlsgdPDp8INbgwey6iPOymP9J0hnD02Wb8dznadWMzOwjpkVJ8TfAR9yrnTPEw==
plc:VsqErgEYQU_V6L_96TP9wthZVBqpROLkNyqJhxiMA8Rhw8TLX3ArKiZnPLNGmREJ4nsE1CoDekK0DFGRFyE4Ig==
查询数据过去一天:
from(bucket: "plc") |> range(start: -1d) |> filter(fn: (r) => r["_measurement"] == "opcua") |> filter(fn: (r) => r["_field"] == "WindSpeed" or r["_field"] == "ActivePower" or r["_field"] == "WindDirection" or r["_field"] == "DataEffectiveFlag")
查询数据过去一小时:
from(bucket: "plc") |> range(start: -1h) |> filter(fn: (r) => r["_measurement"] == "opcua") |> filter(fn: (r) => r["_field"] == "WindSpeed" or r["_field"] == "ActivePower" or r["_field"] == "WindDirection" or r["_field"] == "DataEffectiveFlag")
from(bucket: "plc")
|> range(start: -365d)
|> sort(desc: true)
|> filter(fn: (r) => r._measurement == "opcua")
|> filter(fn: (r) => exists r._value)
|> filter(fn: (r) => r._value == r._value)
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。