Versions Compared

Key

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


separator

Page properties
hiddentrue


Tech review

Status
colourGreen
titletododone

Style guide

Status
colourGreen
titledone

Page status

Status
colourGreen
titlecompletetodo

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

pipe



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 typeDescriptionExample

Status
subtletrue
titletext

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

Status
subtletrue
titlemulti

Expand
titlePro tip...
UI Text Box
typetip

Any field type or data type is susceptible of being transformed to text, so any field can be referenced as a text-string value using the following notation: %{...anyfield}, and %{...anyfield.i} for Cascading Select or Multi-Cascading Select fields, where i is the index that represents the level to be accessed. (i = 0 is used for base level).

"Hello world"

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...
UI Text Box
typetip

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

1, 1.1, -1.1, .1, -.1

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

Include Page
DECADIS:_snip_number_to_text
DECADIS:_snip_number_to_text

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.
  • Number/text: fieldValue(), append(), union(), except(), intersect() and distinct()(for both numeric and text values), [1, 2, 3]/["string_A", "string_B", "string_C"]
  • Issue list: subtasks(), linkedIssues(), transitionLinkedIssues(), filterByFieldValue(), filterByStatus(), filterByIssueType(), filterByResolution(), filterByProject(), append(), union(), except(), intersect() and distinct()

    Learn more about Lists

    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

    Comparison operators

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

    isActive(text user_name)

    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

    Additional data types

    You will find many data type references throughout the documentation that need to be explained in more detail. They all related to one of the categories above.

    UI Expand
    titleText
    Data typeDescriptionExample UI Expand
    titleNumber
    Data typeDescriptionExample UI Expand
    titleList
    Data typeDescriptionExample

    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.

    Image RemovedAvailable functions

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