Influxdb 1.x Filter by field value

I can’t get a filter by column value to work if that column is a field. It works fine if the field is a tag.

Is this supposed to work in flux on influxdb 1.x?

hi @geoff_at_spruik welcome !

can you share your query ?

In Flux, the field key is always in the _field column and the field value is in the _value column. To filter results to a specific field, your query would look something like:

from(bucket: "db/rp")
  |> range(start: -1h)
  |> filter(fn: (r) => r._field == "field-key")

As often happens, when I went to step through the problem to explain, I found that it works. Thanks for the replies