I’m trying to add an annotation query but continue to get “No events found”. The query runs fine in Grafana (as a normal, non-annotation query) and in the InfluxDB Data Explorer. In the browser’s F12 window I see: “Cannot process annotation fields. No time or text present.”
Here’s the query:
data = from(bucket: "sensors")
// |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> range(start: 2024-01-23)
|> filter(fn: (r) => r["_measurement"] == "OpenThermB")
|> filter(fn: (r) => r["_field"] == "value")
|> filter(fn: (r) => r["device"] == "BaseCube")
|> filter(fn: (r) => r["topic"] == "events/BaseCube/OpenTherm/centralheating")
|> keep(columns: ["_time", "_value"])
|> yield(name: "data")
And here is the result:
table
data
_value
no group
boolean
_time
no group
dateTime:RFC3339
0 true 2024-01-23T07:01:01.313Z
0 false 2024-01-23T08:25:43.244Z
0 true 2024-01-23T08:36:25.640Z
0 false 2024-01-23T09:02:55.952Z
0 true 2024-01-23T09:10:58.529Z
When inspecting the query results in Grafana, I see the timestamps in ms as required. Any help will be appreciated.