Type Conversion
TOASCII
❌ Cannot be used in filter queries
Converts the input buffer (binary content, file contents) value into the ASCII character set (Base64 encoding).
Syntax
TOASCII(value)
Name | Type | Description |
---|---|---|
value | mandatory | The buffer content to convert to the ASCII character set. The argument can be any valid expression that resolves to a buffer value (file contents object). |
TOBOOLEAN
✔️ Safe to use in filter queries
Converts the input value to a boolean.
Syntax
TOBOOLEAN(value)
Name | Type | Description |
---|---|---|
value | mandatory | The value to convert to boolean. The argument can be any valid expression that resolves to a value. |
TODATE
✔️ Safe to use in filter queries
Converts the input value to a date. Raises an error if the input value is not a date.
Syntax
TODATE(value)
Name | Type | Description |
---|---|---|
value | mandatory | The value to convert to date. The argument can be any valid expression that resolves to a value. |
TODECIMAL
✔️ Safe to use in filter queries
Converts the input value to a decimal. Raises an error if the input value is not a decimal.
Syntax
TODECIMAL(value)
Name | Type | Description |
---|---|---|
value | mandatory | The value to convert to decimal. The argument can be any valid expression that resolves to a value. |
TOINTEGER
✔️ Safe to use in filter queries
Converts the input value to an integer. Raises an error if the input value is not an integer.
Syntax
TOINTEGER(value)
Name | Type | Description |
---|---|---|
value | mandatory | The value to convert to integer. The argument can be any valid expression that resolves to a value. |
TOTEXT
✔️ Safe to use in filter queries
Converts the input value to text.
Syntax
TOTEXT(value)
Name | Type | Description |
---|---|---|
value | mandatory | The value to convert to text. The argument can be any valid expression that resolves to a value. |