Work with booleans

A boolean type represents a truth value (true or false).

Type name: bool

• Boolean syntax
• Convert data types to booleans
• Negate boolean values

Boolean syntax

Boolean literals are represented by the following:

true
false

Convert data types to booleans

Use the bool() function to convert the following basic types to booleans:

• string: value must be "true" or "false".
• float: value must be 0.0 (false) or 1.0 (true).
• int: value must be 0 (false) or 1 (true).
• uint: value must be 0 (false) or 1 (true).

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

bool(v: 0.0)
// Returns false

bool(v: 0)
// Returns false

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

Convert columns to booleans

Flux lets you iterate over rows in a stream of tables and convert columns to booleans.

To convert the _value column to booleans, use the toBool() function.

data
    |> toBool()

To convert any column to booleans:

1. Use map() to iterate over and rewrite rows.
2. Use bool() to convert columns values to booleans.

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

Negate boolean values

To negate boolean values, use the not logical operator.

not true
// Returns false

not false
// Returns true