Versions Compared

Key

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


Page properties
hiddentrue


Tech review

Status
colourYellowGreen
titleReady for reviewdone

Style guide

Status
colourGreen
titledone

Page status

Status
colourGreenYellow
titleReady for reviewcomplete

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

Panel

On this page

toc

exclude(On this page).*
stylecircle
typeflat
separatorpipe



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

Data typeDescription

Status
subtletrue
titletext

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

Status
subtletrue
titlenumber

This type represents numeric values, and is also used to store date, time and date-time values. Learn more about Dates, times and time zones

Include Page
DECADIS:Number _snip_number_to_text
DECADIS:Number _snip_number_to_text

Status
subtletrue
titlelist

  • Number list: This type represents a collection of numeric 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 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.

Learn more about Working with listsLists

UI Text Box
typetip

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:



Casting

Converting (

converting

casting) data types

ui

Excerpt-

text-box
sizemedium
typeinfo

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
pageSize100
sortByTitle
cqllabel = "parser_function" and space = currentSpace() and parent = currentContent()

UI Text Box
typetip

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, the parser will automatically transform the right-hand side term into a text toString().

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

    Include Page
    Converting data types
    Converting data types
    nopaneltrue


    Excerpt Include
    DECADIS:Contact support
    DECADIS:Contact support
    nopaneltrue