Migrate JWT Parser functions

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

For migrating the individual timezone, you have to map the timezone of JWT DC 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, he best way is to select a timezone which has the same UTC offset as the one on 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 Code locales 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

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

Parser function Data Center	Mapping	Parser function Cloud	Notes
abs()		abs()
acos()	-	-
addDays()		addDays()
addDaysSkippingWeekends()	-	-
addMonths()	-	-
addTime()	-	-
addTimeSkippingWeekends()	-	-
addYears()	-	-
allAvailableOptions()	-	-
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()
datePart()		datePart()
dateTime()	-	-
dateTimeToString()		dateTimeToString()
dateToString()		dateToString()
dayOfTheMonth()		dayOfTheMonth()
dayOfTheWeek()		dayOfTheWeek()
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()	-	-
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()
htmlToTxt()	-	-
indexOf()	-	-
intersect()		intersect()
invertList()	-	-
isAClone()	-	-
isActive()	-	-
isBulkTriggeredTransition()	-	-
isInGroup()	-	-
isInRole()	-	-
isJwtTriggeredTransition()	-	-
issueIDFromKey()	-	-
issueKeyFromID()	-	-
issueKeystoIssueList()		issueKeystoIssueList()
issuesAbove()	-	-
issueSecurityLevel()	-	-
issuesFromJQL()		issuesFromJQL()
issuesUnder()	-	-
issuesUnderEpic()		issuesUnderEpic()
issueType()		issueType()
last()		last()
lastAssigneeInRole()	-	-
lastDayOfTheMonth()	-	-
lastFieldChangeTime()	-	-
latestReleasedUnarchivedVersion()	-	-
latestReleasedVersion()	-	-
leastBusyUserInRole()	-	-
length()		length()
linkedIssues()		linkedIssues()
log10()	-	-
log()	-	-
matches()		matches()
mathOnIssueList()	-	-
mathOnNumberList()	-	-
mathOnStringList()	-	-
max()		max()
max(list)		max(list)
min()		min()
min(list)		min(list)
minute()		minute()
modulus()		modulus()
month()		month()
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()
round()		round()
second()		second()
setBoolean()	-	-
setIssueList()	-	-
setNumber()	-	-
setNumberList()	-	-
setString()	-	-
setStringList()	-	-
shortFormatDuration()	-	-
shortFormatWorkDuration()	-	-
siblingIssues()	-	-
siblingIssuesUnderEpic()		siblingIssuesUnderEpic()
siblingSubtasks()	-	-
similarity()	-	-
sin()	-	-
sinh()	-	-
sort()		sort()	Please note that the variant sort(issueList, field, order) #Output: Issue list is not available in JWT Cloud.
sqrt()	-	-
startDates()	-	-
status()		status()
stringToDate()		stringToDate()	Please note that the variant stringToDate(text, dateTimePattern, language, country ) #Output: Number is not available in JWT Cloud.
sublist()		sublist()
substring()		substring()
subtasks()		subtasks()
subtractDatesSkippingWeekends()	-	-
sum()		sum()
tan()	-	-
tanh()	-	-
textOnIssueList()	-	-
textOnNumberList()	-	-
textOnStringList()	-	-
timeDifference()	-	-
timeInStatus()	-	-
timeInValue()	-	-
timeLogged()	-	-
timePart()		timePart()
timesOfTransition()	-	-
timezone()	-	-
toDegree()	-	-
toLowerCase()		toLowerCase()
toNumber()		toNumber()
toNumberList()		toNumberList()
toRadians()	-	-
toString()		toString()
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()

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

Content

Space Tools