Versions Compared

Key

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


Page properties
hiddentrue


Tech review

Status
titletodo

Style guide

Status
titletodo

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

 values. Learn more about Dates, times and time zones

Pro tip

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

Include Page
DECADIS:Number to text
DECADIS: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, 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...
UI Text Box
typetip
Include Page
DECADIS:Number to text
DECADIS:Number to text

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

Status
subtletrue
titlelist

  • Number /Text list: This type represents a collection of numeric/text values  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 issuesreturned 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

Status
subtletrue
titleBoolean

Comparison Logical operators return a logical, or boolean value of true or false.



Casting (converting) data types

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


Available functions


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

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)