Annotation query returns "No events found"

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.

1 Like