Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

Versions Compared

Old Version 17

changes.mady.by.user Marcel Frank

Saved on

compared with

New Version 18

changes.mady.by.user Iheb Kharab

Saved on

Key

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


UI Text Box
sizemedium
typeinfo

This function returns a number list with the times when the current issue was transitioned from a given status to another given status, ordered by ascending transition time.

An empty string as an argument that is interpreted as any status.


Code Block
languagebash
titleSyntax
linenumberstrue
timesOfTransition(fromStatus, toStatus) #Output: Number list


UI Expand
titleExamples


Parser expressionDescription


Code Block
languagebash
linenumberstrue
dateToString(last(timesOfTransition("", "Done")), LOCAL, USER_LANG)


This example returns the most recent time of when the issue was resolved, based on the local time zone e.g.:

24.06.2020

To achieve this the following functions are used:



UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
fromStatus

Status
subtletrue
titletext

Text containing a valid status name.
toStatus

Status
subtletrue
titletext

Text containing a valid status name.



UI Expand
titleOutput

This function returns a

Status
subtletrue
titlenumber list




UI Text Box
sizemedium
typeinfo
Variant where you can additionally define a specific issue key.


Code Block
languagebash
titleSyntax
linenumberstrue
timesOfTransition(fromStatus, toStatus, issueKey) #Output: Number list


UI Expand
titleExamples


Parser expressionDescription


Code Block
languagebash
linenumberstrue
dateToString(first(timesofTransition("Closed", "", %{parent.key})))


This example returns the date of when the parent issue was reopened for the first time,e.g.:

24.06.2020



UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
fromStatus

Status
subtletrue
titletext

Text containing a valid status name.
toStatus

Status
subtletrue
titletext

Text containing a valid status name.
issueKey

Status
subtletrue
titletext

Text containing a valid issue key. Usually field codes are used.



UI Expand
titleOutput

This function returns a

Status
subtletrue
titlenumber list



Use cases and examples

Page properties report
firstcolumnUse case
headingsJWT feature, Workflow function, Field type, Automated action, Parser functions
cqllabel = "parser_func_timesoftransition" and space = currentSpace()


Page properties
hiddentrue



Status
Tech review

Status
colourGreen
titledone

Style guide

Status
colourGreen
titledone

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



Page properties
hiddentrue


Short description

Returns the timestamps of when a certain transition was executed.

Output

Status
subtletrue
titlenumber list

Available since

Status
subtletrue
colourBlue
title2.2.7

Label