Versions Compared

Key

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


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
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

include

Data typeDescription

Status
subtletrue
titletext

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

P

Expand
titlePro tip...
DECADIS:Number to textDECADIS:Number to text
Tip
typetip

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 Datedate-Timetime values. Learn more about Dates, times and time zonesPro tip

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 lists StatussubtletruetitleBooleanLogical operators return a logical, or boolean value of true or false.

Casting (converting) data types

Lists

UI Text Box
sizemedium
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)