On this page
Throughout the documentation we refer to data types that can be used in the expression parser and its functions and field codes.
Data types define what kind of data e.g. a function needs as an input and what you should expect as an output.
Data types overview
Data type | Description |
---|---|
TEXT | This type represents any kind of text or character string including all kinds of select and multi-select fields |
NUMBER | This type represents numeric values, and is also used to store date, time and date-time values. Learn more about Dates and times If you need the output as text, simply add % in front of the field code or directly insert the field code as text. |
LIST |
Learn more about Lists. If you need to "flatten" the list, or simply convert it to a text, to be written into any field, comment, etc., make sure to have a look at the toString() function! |
BOOLEAN | Some operators and workflow functions return a logical, or boolean, value of |
Casting (converting) data types
Casting (or transforming) data types is very important throughout all functions provided by JWT.
To be able to set, transform or calculate values it might be necessary to turn a text value to a number, a number or a timestamp to a text, and even individual text or number values to a list.
The following functions will help you to achieve that.
Available functions
Function name | Short description | Output |
---|---|---|
issueKeysToIssueList() | Converts a text containing issue keys to an issue list. | ISSUE LIST |
toLogicalValue() | Converts a text and lists to a logical value. | BOOLEAN |
toNumber() | Converts a text to a number. | NUMBER |
toNumberList() | Converts text to a number list. | NUMBER LIST |
toString() | Converts numbers and lists to plain text. | TEXT |
toStringList() | Converts text to a text list. | TEXT LIST |
Whenever you write a numeric term at the right-hand side of the + operator or a comparison operator like =
, and the left-hand side is occupied by a text term, JWT will automatically transform the right-hand side term into a text toString().
Operator | Example |
---|---|
+ |
|
= (any comparison operator) |
|
If you still have questions, feel free to refer to our support team.