Versions Compared

Key

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


Content Layout Macro

UI Text Box
sizemedium
typeinfo

The following detailed list table below shows which JWT DC parser functions can be mapped to JWT Cloud parser functions are valid for a migration and which are not, with possible workarounds on some parser functions which are not available for JWT Cloud., and what needs to be taken into account when doing so.



UI Expand
titleTime 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. 


Image Added JWT DC

Mapping

Image Added JWT Cloud

{SECOND}

{MINUTE}

{HOUR}

{DAY}

{WEEK}

{MONTH}

{YEAR}

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

SECOND

MINUTE

HOUR

DAY

WEEK

MONTH

YEAR

{SUNDAY}

{MONDAY}

{TUESDAY}

{WEDNESDAY}

{THURSDAY}

{FRIDAY}

{SATURDAY}

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

SUNDAY

MONDAY

TUESDAY

WEDNESDAY

THURSDAY

FRIDAY

SATURDAY

{JANUARY}

{FEBRUARY}

{MARCH}

{APRIL}

{MAY}

{JUNE}

{JULY}

{AUGUST}

{SEPTEMBER}

{OCTOBER}

{NOVEMBER}

{DECEMBER}

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

(tick)

JANUARY

FEBRUARY

MARCH

APRIL

MAY

JUNE

JULY

AUGUST

SEPTEMBER

OCTOBER

NOVEMBER

DECEMBER



UI Expand
titleTime 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.

UI Text Box
sizemedium
typeinfo

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

TimezoneUTC offset

Image AddedJWT DC

Image AddedJWT Cloud

Coordinated Universal Time+00:00UTC"UTC"
Central Standard Time-06:00CST"US/Central"
Singapore+08:00SGT"Singapore"



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

Image Added JWT DC

Mapping

 Image Added JWT Cloud

LOCAL-
RUN_AS_LOCAL(tick)RUN_AS_LOCAL
SERVER_LOCAL-



UI Expand
titleLanguages

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

 Image Added JWT DC

Mapping

 Image Added JWT Cloud

RUN_AS_LANG(tick)RUN_AS_LANG
SERVER_LANG


-
USER_LANG-


UI Text Box
typeinfo

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




Image AddedJWT DC parser function

Mapping

Image AddedJWT Cloud parser function

Parser function

Data Center

Mapping

Parser function

Cloud

Notes
abs()(tick)abs()
acos()
(error)
--
addDays()(tick)addDays()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone
DECADIS:Migration_timezone


addDaysSkippingWeekends()
(error)
--
addMonths()
(error)
--
addTime()
(error)
--
addTimeSkippingWeekends()
(error)
--
addYears()
(error)
--
allAvailableOptions

allAvailableItems()
(error)
--
allCommentCreators()
(error)
--
allCommentDates()
(error)
--


allCommenters()
(error)
--
allComments()
(error)
--
allIssuesUnder()
(error)
--
append()(tick)append()
archivedVersions()
(error)
--
asin()
(error)
--
atan()
(error)
--
attachmentUrls()
(error)
--
availableItems()
(error)
--
avg()(tick)avg()
capitalizeWords()
(error)
--
capitalizeWordsFully()
(error)
--
cbrt()
(error)
--
ceil()(tick)ceil()
componentLeader()
(error)
--
componentLeads()
(warning)
--
Replace the function by the field code for Component/s leads.
Code Block
languagebash
%{issue.components.leads}


cos()
(error)
--
cosh()
(error)
--
count()(tick)count()


UI Text Box
typeinfo

Counting specific instances in lists is not supported, i.e. count(number, numberList) and count(text, textList)


datePart()(tick)datePart()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone
DECADIS:Migration_timezone


dateTime()
(error)
--
dateTimeToString()(tick)dateTimeToString()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone_and_language
DECADIS:Migration_timezone_and_language


dateToString()(tick)dateToString()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone_and_language
DECADIS:Migration_timezone_and_language


dayOfTheMonth()(tick)dayOfTheMonth()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone
DECADIS:Migration_timezone


dayOfTheWeek()(tick)dayOfTheWeek()
dayOfTheWeekToString()(warning)-

Replace the function by:

Code Block
languagebash
%{getMatchingValue(dayOfTheWeek({issue.created}, RUN_AS_LOCAL), [1,2,3,4,5,6,7],["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"])}


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone
DECADIS:Migration_timezone


dayOfTheWeekToString()--


dayOfTheYear()
(error)
--
daysInTheMonth()
(warning)
--

Replace the function by:

Code Block
languagebash
%{getMatchingValue(month({issue.created}, RUN_AS_LOCAL), [1,2,3,4,5,6,7,8,9,10,11,12], [31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31])}


defaultUserForRole()
(error)
--
displayNameToUser()
(error)
--
distinct()(tick)distinct()
earliestUnreleasedUnarchivedVersion()
(error)
--
earliestUnreleasedVersion()
(error)
--
epic()(tick)epic()
escapeHTML()
(error)
--
except()(tick)except()
fieldChangeTimes()
(error)
--
fieldHistory()
(error)
--
fieldValue()(tick)
filledInTransitionScreen()
(error)
--
filterByCardinality()(tick)filterByCardinality()
filterByFieldValue()
(error)
--
filterByIssueType()(tick)
filterByPredicate()
(error)
--
filterByProject()(tick)
filterByProjectCategory()
(error)
--
filterByResolution()(tick)
filterByStatus()(tick)
filterByStatusCategory()
(error)
--
filterByValue()(tick)filterByValue()
findModify()
(error)
--
findPattern()(tick)findPattern()
findPatternIgnoreCase()(tick)findPatternIgnoreCase()
findReplaceAll()(tick)findReplaceAll()
findReplaceAllIgnoreCase()(tick)findReplaceAllIgnoreCase()
findReplaceFirst()(tick)findReplaceFirst()
findReplaceFirstIgnoreCase()(tick)findReplaceFirstIgnoreCase()
first()(tick)first()
floor()(tick)floor()
formatDuration()
(error)
--
formatWorkDuration()
(error)
--
fullNameToUser()--
getAscii()
(error)
--
getBoolean()
(error)
--

In JWT Cloud, no variables can be set or obtained.


getIssueList()
(error)
--
getIssuesFromProjects()(warning)-


UI Text Box
typeinfo

This is a legacy function in JWT DC. Please use issuesFromJQL(), e.g.

, Code Block
languagebash

 
%{issuesFromJQL("project

in

('SGC,

CRM')")}


getMatchingValue()(tick)getMatchingValue()
getNumber()
(error)
--
In JWT Cloud, no variables can be set or obtained.


getNumberList()
(error)
--

In JWT Cloud, no variables can be set or obtained.


getString()
(error)
--

In JWT Cloud, no variables can be set or obtained.


getStringList()
(error)
--
In JWT Cloud, no variables can be set or obtained.


getUserKey()
(error)
--
groupUserBelongsTo()
(error)
--
hasChanged()
(error)
--
hour()(tick)hour()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone
DECADIS:Migration_timezone


htmlToTxt()
(error)
--
indexOf()
(error)
--
intersect()(tick)intersect()
invertList()
(error)
--
isAClone()
(error)
--
isActive()
(error)
--
isBulkTriggeredTransition()
(error)
--
isInGroup()
(error)
--
isInRole()
(error)
--
isJwtTriggeredTransition()
(error)
--
issueIDFromKey()
(error)
--
issueKeyFromID()
(error)
--
issueKeystoIssueList()(tick)issueKeystoIssueList()
issuesAbove()
(error)
--
issueSecurityLevel()
(error)
--
issuesFromJQL()(tick)issuesFromJQL()


UI Text Box
typeinfo

Executing the JQL query as an arbitrary user is not supported, i.e. 
issuesFromJQL(jqlQuery, userName)


issuesUnder()
(error)
--
issuesUnderEpic()(tick)issuesUnderEpic()
issueType()(tick)

issueType()


last()(tick)last()
lastAssigneeInRole()
(error)
--
lastDayOfTheMonth()
(error)
--
lastFieldChangeTime()
(error)
--
latestReleasedUnarchivedVersion()
(error)
--

latestReleasedVersion()

(error)
--
leastBusyUserInRole()
(error)
--
length()(tick)length()
linkedIssues()(warning)linkedIssues()


UI Text Box
typeinfo

In JWT

CLoud

Cloud, no links to Epics are included.


log10()
(error)
--
log()
(error)
--
matches()(tick)matches()
mathOnIssueList()
(error)
--
mathOnNumberList()
(error)
--
mathOnStringList()
(error)
--
max()(tick)max()
max(list)(tick)max(list)
min()(tick)min()
min(list)(tick)min(list)
minute()(tick)minute()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone
DECADIS:Migration_timezone


modulus()(tick)modulus()
month()(tick)month()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone
DECADIS:Migration_timezone


monthToString()
(error)
--
nextDayOfTheWeek()
(error)
--
nextTime()
(error)
--

JWT Calendars are not availbale in JWT Cloud.


nextUserInGroup()
(error)
--
nthElement()(tick)nthElement()
numberOfAvailableItems()
(error)
--
numberOfRemoteIssueLinks()
(error)
--
numberOfSelectedItems()
(error)
--
option()
(error)
--
parent()
(error)
--
pow()
(error)
--
previousValue()
(error)
--
priority()
(error)
--
project()(tick)

project()


projectCategory()
(error)
--
projectIDFromKey()
(error)
--
projectKey()
(error)
--
projectKeys()
(error)
--
projectLead()
(error)
--
projectLeader()
(error)
--
projectName()(warning)-


UI Text Box
typeinfo

Replace the function by using a Jira expression:

Code Block
languagebash
%{jiraExpression("new Project(projectName).name")}

where projectName is the parameter of projectName()


projectProperty()
(error)
--
projectPropertyExists()
(error)
--
projectType()(warning)-


UI Text Box
typeinfo

Replace the function by using a Jira expression:

Code Block
languagebash
%{jiraExpression("new Project(projectName.projectTypeKey")}

where projectName is the parameter of projectType()


random()(tick)random()
releaseDates()
(error)
--
releasedVersions()
(error)
--
releasedVersionsBySequence()
(error)
--
remainder()
(error)
--
replaceAll()(tick)replaceAll()
replaceFirst()(tick)replaceFirst()
resolution()(tick)

resolution()


rolesUserPlays()--
round()(tick)round()
second()(tick)second()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone
DECADIS:Migration_timezone


setBoolean()
(error)
--
In JWT  Cloud, no variables can be set or obtained.


setIssueList()
(error)
--

In JWT  Cloud, no variables can be set or obtained.


setNumber()
(error)
--
In JWT  Cloud, no variables can be set or obtained.


setNumberList()
(error)
--

In JWT  Cloud, no variables can be set or obtained.


setString()
(error)
--

In JWT  Cloud, no variables can be set or obtained


setStringList()
(error)
--

In JWT  Cloud, no variables can be set or obtained.


shortFormatDuration()
(error)
--
shortFormatWorkDuration()
(error)
--
siblingIssues()
(error)
--
siblingIssuesUnderEpic()(tick)siblingIssuesUnderEpic()
siblingSubtasks()
(error)
--
similarity()
(error)
--
sin()
(error)
--
sinh()
(error)
--
sort()(tick)sort()


UI Text Box
typeinfo

The variant

Code Block
languagebash
sort(issueList, field, order) #Output: Issue list

is not available in JWT Cloud.


sqrt()
(error)
--
startDates()
(error)
--
status()(tick)

status()


stringToDate()(tick)stringToDate()


UI Text Box
typeinfo

The variant

Code Block
languagebash
stringToDate(text, dateTimePattern, language, country ) #Output: Number

is not available in JWT Cloud.


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone_and_dateTimePattern
DECADIS:Migration_timezone_and_dateTimePattern


sublist()(tick)sublist()
substring()(tick)substring()
subtasks()(tick)subtasks()
subtractDatesSkippingWeekends()
(error)
--
sum()(tick)sum()
tan()
(error)
--
tanh()
(error)
--
textOnIssueList()
(error)
--
textOnNumberList()
(error)
--
textOnStringList()
(error)
--
timeDifference()
(error)
--

JWT Calendars are not implemented in JWT Cloud.


timeInStatus()
(error)
--
timeInValue()
(error)
--
timeLogged()
(error)
--
timePart()(tick)timePart()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone
DECADIS:Migration_timezone


timesOfTransition()
(error)-
--
timeZone()(warning)-


UI Text Box
typeinfo

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()-
timezone()(error)-toDegree()(error)
-
toLowerCase()(tick)toLowerCase()
toNumber()(tick)toNumber()
toNumberList()(tick)toNumberList()
toRadians()
(error)
--
toString()(tick)toString()


UI Text Box
typeinfo

Submitting an arbitrary separator for converting lists is not supported, i.e. 
toString(textList, separator)


toStringList()(tick)toStringList()
toUpperCase()(tick)toUpperCase()
transitionLinkedIssues()
(error)
--
transitivelyLinkedIssues()
(error)
--
trim()(tick)trim()
unescapeHTML()(tick)-
union()(tick)union()
unreleasedVersions()
(error)
--
unreleasedVersionsBySequence()
(error)
--
userDisplayName()
(error)
--
userEmail()
(error)
--
userFullName()
(error)
--
userProperty()
(error)
--
usersInGroup()
(error)
--
usersInRole()
(error)
--
usersWhoTransitioned()
(error)
--
usersWithEmail()
(error)
--
weekOfTheYear()
(error)
--
wikiToHTML()
(error)
--
withinCalendar()
(error)
--
year()(tick)year()


UI Text Box
typeinfo

Include Page
DECADIS:Migration_timezone
DECADIS:Migration_timezone




Excerpt Include
DECADIS:Contact support
DECADIS:Contact support
nopaneltrue