bool() function

bool() converts a value to a boolean type.

Function type signature
(v: A) => bool
For more information, see Function type signatures.



(Required) Value to convert.


Convert strings to booleans

bool(v: "true")

// Returns true
bool(v: "false")// Returns false

Convert numeric values to booleans

bool(v: 1.0)

// Returns true
bool(v: 0.0)

// Returns false
bool(v: 1)

// Returns true
bool(v: 0)

// Returns false
bool(v: uint(v: 1))

// Returns true
bool(v: uint(v: 0))// Returns false

Convert all values in a column to booleans

If converting the _value column to boolean types, use toBool(). If converting columns other than _value, use map() to iterate over each row and bool() to covert a column value to a boolean type.

    |> map(fn: (r) => ({r with powerOn: bool(v: r.powerOn)}))

View example input and ouput

Was this page helpful?

Thank you for your feedback!

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.