toBool() function
The toBool() function converts all values in the _value column to booleans.
Function type: Type conversion
toBool()
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.
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) }))
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support or submit feedback, the following resources are available:
- Post in the InfluxData Community.
- Submit documentation issues to the InfluxDB 2.0 documentation repository.
- Submit InfluxDB issues to the InfluxDB repository.
For our InfluxDB Cloud customers, InfluxData Support is also available.