Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


exclude

Page properties
hiddentrue


Tech review

Status
colourGreen
titletododone

Style guide

Status
colourGreen
titledone

Page status

Status
colourGreen
titletodocomplete

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged

Panel

On this page

Table of Contents

(On this page).*stylecircletypeflatseparatorpipe



UI Text Box
sizemedium
typeinfo

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

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 types in JWT

type

Data typeDescription

Status
subtletrue
titletext

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

Expand
titlePro tip...
Include Page
DECADIS:Number to textDECADIS:Number to text
Tip
tip

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

Status
subtletrue
titlenumber

This type represents numeric values, and is also used to store Date date, Time time and Date-Time (

Status
subtletrue
titledate_time
) values. When storing any temporal value, the number represents the milliseconds elapsed since January 1, 1970, 00:00:00 GMT.

UI Expand
titlePro tip...

date-time values. Learn more about Dates, times and time zones

Include Page
DECADIS:_snip_number_to_text
DECADIS:_snip_number_to_text

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

Status
subtletrue
titlelist

  • Number
/Text values
  • 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
/
  •  values.
  • Text list: This type represents a collection of text values
. It is used to read the value of a numeric/text field in a selection of issues
  • returned by various functions. The size may vary from 0 to any number of text values.
  • 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.
StatussubtletruetitleBoolean
Comparison operators return a logical value true or false.
Casting (converting) data types

Learn more about Lists

UI Text Box
size
medium
type
info

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.

Image RemovedAvailable functions

Page properties report
firstcolumnFunction
headingsShort description, Output, Available since
pageSize100
sortByTitle
cqllabel = "parser_function" and space = currentSpace() and parent = currentContent()

tip

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!


Status
subtletrue
titleBoolean

Some operators, workflow functions, parser functions, and automation elements return a logical, or boolean, value of true or false.

These examples include, but are not limited to:



Converting (casting) data types

Excerpt Include
Converting data types
Converting data types
nopaneltrue


Excerpt Include
DECADIS:Contact support
DECADIS:Contact support
nopaneltrue

Automatic casting from Number to Text-String

UI Text Box
typetip

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)