Documentation

contains() function

The contains() function tests whether a value is a member of a set. If the value is a member of the set, the function returns true. If the value is not a member of the set, the functions returns false.

contains(
  value: 1,
  set: [1,2,3]
)

Parameters

value

The value for which to search.

Data type: Boolean | Integer | UInteger | Float | String | Time

set

The set of values in which to search.

Data type: Array of Booleans | Integers | UIntegers | Floats | Strings | Times

Examples

Filter on a set of specific fields
fields = ["load1", "load5", "load15"]

from(bucket: "example-bucket")
  |> range(start:start, stop: stop)
  |> filter(fn: (r) =>
      r._measurement == "system" and
      contains(value: r._field, set: fields)
  )

New! Cloud or OSS?

InfluxDB OSS 2.0 now generally available!

InfluxDB OSS 2.0 is now generally available and ready for production use. See the InfluxDB OSS 2.0 release notes.

For information about upgrading to InfluxDB OSS 2.0, see: