Migrate JWT parser functions

The table below shows which JWT DC parser functions can be mapped to JWT Cloud parser functions, and what needs to be taken into account when doing so.

Time Macros

JWT DC offers Time Macros for accessing date and time values like {SUNDAY} for the number of this day in the week (=7). The notion is a "macro", i.e. those keywords are enclosed in {}. In the JWT Cloud expression parser, they are noted as constants without curly brackets.

JWT DC

Mapping

JWT Cloud

{SECOND}

{MINUTE}

{HOUR}

{DAY}

{WEEK}

{MONTH}

{YEAR}

SECOND

MINUTE

HOUR

DAY

WEEK

MONTH

YEAR

{SUNDAY}

{MONDAY}

{TUESDAY}

{WEDNESDAY}

{THURSDAY}

{FRIDAY}

{SATURDAY}

SUNDAY

MONDAY

TUESDAY

WEDNESDAY

THURSDAY

FRIDAY

SATURDAY

{JANUARY}

{FEBRUARY}

{MARCH}

{APRIL}

{MAY}

{JUNE}

{JULY}

{AUGUST}

{SEPTEMBER}

{OCTOBER}

{NOVEMBER}

{DECEMBER}

JANUARY

FEBRUARY

MARCH

APRIL

MAY

JUNE

JULY

AUGUST

SEPTEMBER

OCTOBER

NOVEMBER

DECEMBER

Time Zones

The JWT DC expression parser offers a couple of time zones which can be used as time zone parameter for the parser functions described in Dates, times and time zones.

All the time zones in Time Zone Abbreviations - Worldwide List can be used as a value for a timezone when using the JWT DC expression parser.

The JWT Cloud expression parser relies on the List of tz database time zones, column "TZ database name". It has to be quoted when used as a parameter in a JWT Cloud parser function.

Using these kind of timezone names is especially useful, if you relate to a region with daylight savings time (DST), since this behavior is covered as well, while for timezone abbreviations, the user has to set, e.g. CET or CEST.

Timezone abbreviations may also be ambiguous, like e.g. "CST", which stands for Central Standard time (UTC-6), Cuba Standard Time (UTC-5), and also China Standard Time (UTC+8).

Fortunately, the JWT DC parser function timeZone() accepts the same kind of parameter like JWT Cloud, e.g. "Pacific/Auckland", so you may also want to update your JWT DC parser function call accordingly.

If you are using a time zone abbreviation in JWT DC, you have to map it to the timezone in JWT Cloud by using Time Zone Abbreviations - Worldwide List as source and List of tz database time zones as target. If there are several alternatives, the best way is to select a timezone which has the same UTC offset as the one in JWT DC.

Examples

Timezone	UTC offset	JWT DC	JWT Cloud
Coordinated Universal Time	+00:00	UTC	"UTC"
Central Standard Time	-06:00	CST	"US/Central"
Singapore	+08:00	SGT	"Singapore"

This table shows how the constants for timezones in JWT DC can be mapped to JWT Cloud.

JWT DC	Mapping	JWT Cloud
LOCAL	-
RUN_AS_LOCAL		RUN_AS_LOCAL
SERVER_LOCAL	-

Languages

This table shows how the constants for languages in JWT DC can be mapped to JWT Cloud.

JWT DC	Mapping	JWT Cloud
RUN_AS_LANG		RUN_AS_LANG
SERVER_LANG	-
USER_LANG	-

JWT Cloud offers the option of using most common ISO 639-1 Codes, like the two-letter version "en", or the four-letter version "en-gb" etc.. The string is not case sensitive, so "EN" is valid as well. You don't have to use the hyphen(-), an underscore will work as well, i.e. "en-gb" is equivalent to "en_GB". If the language is not available (e.g. "english"), an error is returned.

These locales may be used instead of SERVER_LANG or USER_LANG

JWT DC parser function	Mapping	JWT Cloud parser function	Notes
abs()		abs()
acos()	-	-
addDays()		addDays()	The parameter timezone has to be migrated according to Time zones (see top of this page).
addDaysSkippingWeekends()	-	-
addMonths()	-	-
addTime()	-	-
addTimeSkippingWeekends()	-	-
addYears()	-	-
allAvailableItems()	-	-
allCommentCreators()	-	-
allCommentDates()	-	-
allCommenters()	-	-
allComments()	-	-
allIssuesUnder()	-	-
append()		append()
archivedVersions()	-	-
asin()	-	-
atan()	-	-
attachmentUrls()	-	-
availableItems()	-	-
avg()		avg()
capitalizeWords()	-	-
capitalizeWordsFully()	-	-
cbrt()	-	-
ceil()		ceil()
componentLeader()	-	-
componentLeads()	-	-
cos()	-	-
cosh()	-	-
count()		count()	Counting specific instances in lists is not supported, i.e. `count(number, numberList)` and `count(text, textList)`
datePart()		datePart()	The parameter timezone has to be migrated according to Time zones (see top of this page).
dateTime()	-	-
dateTimeToString()		dateTimeToString()	Please note, that the parameter timezone has to be migrated according to Time zones (see top of this page), the parameter language has to be migrated according to L anguages (see top of this page) and the values for parameter dateTimePattern differ: JWT DC uses the Java patterns, JWT Cloud uses the moment patterns.
dateToString()		dateToString()	Please note, that the parameter timezone has to be migrated according to Time zones (see top of this page), the parameter language has to be migrated according to L anguages (see top of this page) and the values for parameter dateTimePattern differ: JWT DC uses the Java patterns, JWT Cloud uses the moment patterns.
dayOfTheMonth()		dayOfTheMonth()	The parameter timezone has to be migrated according to Time zones (see top of this page).
dayOfTheWeek()		dayOfTheWeek()	The parameter timezone has to be migrated according to Time zones (see top of this page).
dayOfTheWeekToString()	-	-
dayOfTheYear()	-	-
daysInTheMonth()	-	-
defaultUserForRole()	-	-
displayNameToUser()	-	-
distinct()		distinct()
earliestUnreleasedUnarchivedVersion()	-	-
earliestUnreleasedVersion()	-	-
epic()		epic()
escapeHTML()	-	-
except()		except()
fieldChangeTimes()	-	-
fieldHistory()	-	-
fieldValue()		fieldValue()
filledInTransitionScreen()	-	-
filterByCardinality()		filterByCardinality()
filterByFieldValue()	-	-
filterByIssueType()		filterByIssueType()
filterByPredicate()	-	-
filterByProject()		filterByProject()
filterByProjectCategory()	-	-
filterByResolution()		filterByResolution()
filterByStatus()		filterByStatus()
filterByStatusCategory()	-	-
filterByValue()		filterByValue()
findModify()	-	-
findPattern()		findPattern()
findPatternIgnoreCase()		findPatternIgnoreCase()
findReplaceAll()		findReplaceAll()
findReplaceAllIgnoreCase()		findReplaceAllIgnoreCase()
findReplaceFirst()		findReplaceFirst()
findReplaceFirstIgnoreCase()		findReplaceFirstIgnoreCase()
first()		first()
floor()		floor()
formatDuration()	-	-
formatWorkDuration()	-	-
fullNameToUser()	-	-
getAscii()	-	-
getBoolean()	-	-
getIssueList()	-	-
getIssuesFromProjects()		-	This is a legacy function in JWT DC. Please use issuesFromJQL(), e.g. `%{issuesFromJQL("project in ('SGC, CRM')")}`
getMatchingValue()		getMatchingValue()
getNumber()	-	-
getNumberList()	-	-
getString()	-	-
getStringList()	-	-
getUserKey()	-	-
groupUserBelongsTo()	-	-
hasChanged()	-	-
hour()		hour()	The parameter timezone has to be migrated according to Time zones (see top of this page).
htmlToTxt()	-	-
indexOf()	-	-
intersect()		intersect()
invertList()	-	-
isAClone()	-	-
isActive()	-	-
isBulkTriggeredTransition()	-	-
isInGroup()	-	-
isInRole()	-	-
isJwtTriggeredTransition()	-	-
issueIDFromKey()	-	-
issueKeyFromID()	-	-
issueKeystoIssueList()		issueKeystoIssueList()
issuesAbove()	-	-
issueSecurityLevel()	-	-
issuesFromJQL()		issuesFromJQL()	Executing the JQL query as an arbitrary user is not supported, i.e. `issuesFromJQL(jqlQuery, userName)`
issuesUnder()	-	-
issuesUnderEpic()		issuesUnderEpic()
issueType()		issueType()
last()		last()
lastAssigneeInRole()	-	-
lastDayOfTheMonth()	-	-
lastFieldChangeTime()	-	-
latestReleasedUnarchivedVersion()	-	-
latestReleasedVersion()	-	-
leastBusyUserInRole()	-	-
length()		length()
linkedIssues()		linkedIssues()	In JWT Cloud, no links to Epics are included.
log10()	-	-
log()	-	-
matches()		matches()
mathOnIssueList()	-	-
mathOnNumberList()	-	-
mathOnStringList()	-	-
max()		max()
max(list)		max(list)
min()		min()
min(list)		min(list)
minute()		minute()	The parameter timezone has to be migrated according to Time zones (see top of this page).
modulus()		modulus()
month()		month()	The parameter timezone has to be migrated according to Time zones (see top of this page).
monthToString()	-	-
nextDayOfTheWeek()	-	-
nextTime()	-	-
nextUserInGroup()	-	-
nthElement()		nthElement()
numberOfAvailableItems()	-	-
numberOfRemoteIssueLinks()	-	-
numberOfSelectedItems()	-	-
option()	-	-
parent()	-	-
pow()	-	-
previousValue()	-	-
priority()	-	-
project()		project()
projectCategory()	-	-
projectIDFromKey()	-	-
projectKey()	-	-
projectKeys()	-	-
projectLead()	-	-
projectLeader()	-	-
projectName()		-	Replace the function by using a Jira expression: %{jiraExpression("new Project(projectName).name")} where projectName is the parameter of projectName()
projectProperty()	-	-
projectPropertyExists()	-	-
projectType()		-	Replace the function by using a Jira expression: %{jiraExpression("new Project(projectName.projectTypeKey")} where projectName is the parameter of projectType()
random()		random()
releaseDates()	-	-
releasedVersions()	-	-
releasedVersionsBySequence()	-	-
remainder()	-	-
replaceAll()		replaceAll()
replaceFirst()		replaceFirst()
resolution()		resolution()
rolesUserPlays()	-	-
round()		round()
second()		second()	The parameter timezone has to be migrated according to Time zones (see top of this page).
setBoolean()	-	-
setIssueList()	-	-
setNumber()	-	-
setNumberList()	-	-
setString()	-	-
setStringList()	-	-
shortFormatDuration()	-	-
shortFormatWorkDuration()	-	-
siblingIssues()	-	-
siblingIssuesUnderEpic()		siblingIssuesUnderEpic()
siblingSubtasks()	-	-
similarity()	-	-
sin()	-	-
sinh()	-	-
sort()		sort()	The variant sort(issueList, field, order) #Output: Issue list is not available in JWT Cloud.
sqrt()	-	-
startDates()	-	-
status()		status()
stringToDate()		stringToDate()	The variant stringToDate(text, dateTimePattern, language, country ) #Output: Number is not available in JWT Cloud. Please note, that the parameter timezone has to be migrated according to Time zones (see top of this page), the values for parameter dateTimePattern differ: JWT DC uses the Java patterns, JWT Cloud uses the moment patterns.
sublist()		sublist()
substring()		substring()
subtasks()		subtasks()
subtractDatesSkippingWeekends()	-	-
sum()		sum()
tan()	-	-
tanh()	-	-
textOnIssueList()	-	-
textOnNumberList()	-	-
textOnStringList()	-	-
timeDifference()	-	-
timeInStatus()	-	-
timeInValue()	-	-
timeLogged()	-	-
timePart()		timePart()	The parameter timezone has to be migrated according to Time zones (see top of this page).
timesOfTransition()	-	-
timeZone()		-	While the timeZone() function itself is not supported in JWT Cloud, you can simply replace the function call with its text parameter, if it represents a valid "TZ database name" ( see JWT Cloud Time zones). E.g. just replace `timePart({issue.created}, timeZone("Pacific/Auckland"))` by `timePart({issue.created}, "Pacific/Auckland")`
toDegrees()	-	-
toInteger()	-	-
toLowerCase()		toLowerCase()
toNumber()		toNumber()
toNumberList()		toNumberList()
toRadians()	-	-
toString()		toString()	Submitting an arbitrary separator for converting lists is not supported, i.e. `toString(textList, separator)`
toStringList()		toStringList()
toUpperCase()		toUpperCase()
transitionLinkedIssues()	-	-
transitivelyLinkedIssues()	-	-
trim()		trim()
unescapeHTML()		-
union()		union()
unreleasedVersions()	-	-
unreleasedVersionsBySequence()	-	-
userDisplayName()	-	-
userEmail()	-	-
userFullName()	-	-
userProperty()	-	-
usersInGroup()	-	-
usersInRole()	-	-
usersWhoTransitioned()	-	-
usersWithEmail()	-	-
weekOfTheYear()	-	-
wikiToHTML()	-	-
withinCalendar()	-	-
year()		year()	The parameter timezone has to be migrated according to Time zones (see top of this page).

If you still have questions, feel free to refer to our support team.

Content

Space Tools