toBool() function
The toBool()
function converts all values in the _value
column to booleans.
Function type: Type conversion
Output data type: Boolean
toBool()
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.
Examples
from(bucket: "telegraf")
|> filter(fn:(r) =>
r._measurement == "mem" and
r._field == "used"
)
|> toBool()
Function definition
toBool = (tables=<-) =>
tables
|> map(fn:(r) => ({ r with _value: bool(v: r._value) }))
Bug Reports and Feedback
Thank you for being willing to help test InfluxDB v2.0 alpha! Feedback and bug reports are welcome and encouraged both for InfluxDB and this documentation. Submit feedback using one of the following methods:
- Post in the InfluxData Community
- In the InfluxDB UI, click Feedback in the left navigation bar.
- Submit documentation issues to the InfluxDB 2.0 documentation repository.
- Submit InfluxDB issues to the InfluxDB repository.