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)
)