You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 18 Next »

On this page

Throughout the documentation we refer to data types that can be used in the expression parser and its functions.

Data types define what kind of data a function needs as input and what you should expect as output.


The most common data types

Data typeDescription

TEXT

This type represents any kind of text or character string including all kinds of select and multi-select fields

Unable to render {include} The included page could not be found.

Any field type or data type is can be transformed to text, simply rempo

NUMBER

This type represents numeric values, and is also used to store Date, Time and Date-Time (DATE_TIME) values. When storing any temporal value, the number represents the milliseconds elapsed since January 1, 1970, 00:00:00 GMT.

Pro tip...

Number or Date-Time fields can be referenced as numbers using the following notation: {...somefield}

LIST

  • Number/Text list: This type represents a collection of numeric/text values returned by various functions. The size may vary from 0 to any number of numeric/text values. It is used to read the value of a numeric/text field in a selection of issues.
  • Issue list: This type represents a collection of issues. The size may vary from 0 to any number of issues. It is returned by issue selection of filtering functions.

BOOLEAN

Comparison operators return a logical value true or false.


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


Automatic casting from Number to Text-String

Whenever you write a numeric term at the right-hand side of concat operator + or a comparison operator like = , and the left-hand side is occupied by a text-string term, the parser will automatically transform the right-hand side term into a string

  • + (string concat): "His age is " + 30 is equivalent to "His age is " + toString(30)
  • = (any comparison operator): "30" = 30 is equivalent to "30" = toString(30)