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

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

Status
subtletrue
titlelist

  • Number/Text 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/text values. It is used to read the value of a numeric/text field in a selection of issues.
  • 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()

Status
subtletrue
titleBoolean

Comparison operators return a logical value true or false. isActive(text user_name)


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

Status
subtletrue
titleuser

This type represents a user. The user is mapped to its Atlassian account ID, i.e. a 

Status
subtletrue
titletext

557068:145e0983-5707-439c-80e4-1160dd57g114

Status
subtletrue
titledate

This type represents a date value. A

Status
subtletrue
titledate
is mapped to a 
Status
subtletrue
titletext

2020-06-15

Status
subtletrue
titledate_time

This type represents a value that contain both date and time parts. A 

Status
subtletrue
titledate_time
is mapped to a 
Status
subtletrue
titletext

2019-04-01T14:19:07.060+0200

Status
subtletrue
titleIssue type

This type represents the type of an issue and mapped to its name, i.e. a 

Status
subtletrue
titletext

Improvement

Status
subtletrue
titlestatus

This type represents the type of an issue and mapped to its name, i.e. a 

Status
subtletrue
titletext

Open

Status
subtletrue
titleStatus category

This type represents the category of the status of an issue. It's mapped to a TEXT

Done

Status
subtletrue
titlepriority

This type represents the priority of an issue. It's mapped to a TEXT

Critical

Status
subtletrue
titleproject

This type represents the project to which an issue belongs. A 

Status
subtletrue
titleproject
is mapped to its key, i.e. a 
Status
subtletrue
titletext

HR

Status
subtletrue
titleresolution

This type represents the resolution of an issue. It's mapped to its name, i.e. a 

Status
subtletrue
titletext

Won't fix

Status
subtletrue
titlesecurity

This type represents the security level of an issue. It's mapped to its name, i.e. a 

Status
subtletrue
titletext

Classified



UI Expand
titleNumber


Data typeDescriptionExample








UI Expand
titleList


Data typeDescriptionExample

Status
subtletrue
titleuser_list

This type represents a list of users. The user is mapped to its Atlassian account ID, i.e. a 

Status
subtletrue
titletext

557068:145e0983-5707-439c-80e4-1160dd57g114

Status
subtletrue
titleattachment list

This type represents a list of attachments. An

Status
subtletrue
titleattachment
is mapped to its filename, i.e. a 
Status
subtletrue
titletext

file1.txt,readme.pdf,screenshot.png

Status
subtletrue
titlecomponent list

This type represents a list of components. A 

Status
subtletrue
titlecomponent
is mapped to its name, i.e. a 
Status
subtletrue
titletext

Web Site,Authenticator,Statistics

Status
subtletrue
titleversion list

This type represents a list of versions. A 

Status
subtletrue
titleversion
is mapped to its name, i.e. a 
Status
subtletrue
titletext

1.0,2.0,2.1

Status
subtletrue
titlelabel list

This type represents a list of labels. A

Status
subtletrue
titlelabel
is mapped to a 
Status
subtletrue
titletext

web,customer,java,mobile



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