toBool() function

The toBool() function converts all values in the _value column to booleans.

Function type: Type conversion


Supported data types: Float | Integer | String | Uinteger

To convert values in a column other than _value, define a custom function patterned after the function definition, but replace _value with your desired column.


from(bucket: "telegraf")
  |> filter(fn:(r) =>
    r._measurement == "mem" and
    r._field == "used"
  |> toBool()

Function definition

toBool = (tables=<-) =>
    |> map(fn:(r) => ({ r with _value: bool(v: r._value) }))

Used functions: map(), bool()

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: