Jira Workflow Toolbox uses powerful parser expressions for interpreting all kinds of data.
If you are new to JWT, we suggest starting with the JWT expression editor.
Data types
📚 Expression parser function library
| Function name | Short description | Output |
|---|---|---|
| abs() |
Returns the absolute value of the input number. |
number |
| acos() |
Returns the arccosine value of the input number. |
number |
| addDays() |
Adds or subtracts days to or from any given date. |
number |
| addDaysSkippingWeekends() |
Adds or subtracts natural days (or working days) to or from any given date. |
number |
| addMonths() |
Adds or subtracts months to from any given date. |
number |
| addTime() |
Adds or subtracts days to or from any given timestamp based on a JWT calendar specification. |
number |
| addTimeSkippingWeekends() |
Adds or subtracts time to or from any given date. |
number |
| addYears() |
Adds or subtracts years to or from any given date. |
number |
| allAvailableItems() |
This function returns all available options of selectable fields. |
text list |
| allCommentCreators() |
Returns all comment creators |
text list |
| allCommentDates() |
Returns the dates of specified comments |
number list |
| allCommenters() |
Returns all comment authors and updaters |
text list |
| allComments() |
Returns defined comments |
text list |
| allIssuesUnder() |
Returns issues located in any level under a given parent issue according to Advanced Roadmaps hierarchy. |
issue list |
| append() |
Combines the elements of two lists. |
list |
| archivedVersions() |
Returns all archived versions. |
text list |
| asin() |
Returns the arcsine value of the input number. |
number |
| atan() |
Returns the arctangent value of the input number. |
number |
| attachmentUrls() |
Returns all attachment URLs of the given issue(s). |
text list |
| availableItems() |
Returns available options of selectable fields - disabled options will be ignored. |
text list |
| avg() |
Calculates the average values of a given number list. |
number |
| capitalizeWords() |
Capitalizes a text, only updating the first letters. |
text |
| capitalizeWordsFully() |
Capitalizes an entire text. |
text |
| cbrt() |
Returns the cube root of the input number. |
number |
| ceil() |
Returns the next higher integer. |
number |
| componentLeader() |
Returns the user name(s) of specified component leads |
text |
| componentLeads() |
Returns the user name(s) of specified component leads |
text |
| cos() |
Returns the cosine of the given number. |
number |
| cosh() |
Returns the hyperbolic cosine of the input number. |
number |
| count() |
Returns the number of elements in a text, number or issue list. |
number |
| datePart() |
Returns the date part of any given timestamp. |
number |
| dateTime() |
Creates a timestamp based on input values. |
number |
| dateTimeToString() |
Returns the timestamp of any given date in text form. |
text |
| dateToString() |
Returns the timestamp of a date part of any given date in text form. |
text |
| dayOfTheMonth() |
Returns the day of the month of any given timestamp. |
number |
| dayOfTheWeek() |
Returns the day of the week of any given timestamp. |
number |
| dayOfTheWeekToString() |
Returns the day of the week of any given timestamp in text form. |
text |
| dayOfTheYear() |
Returns the day of the year of any given timestamp. |
number |
| daysInTheMonth() |
Returns the number of days in a month of any given timestamp. |
number |
| defaultUserForRole() |
Returns the user name of the default project role user. |
text |
| displayNameToUser() |
Returns the user name for a given user. |
text |
| distinct() |
Removes all duplicates from a number, text, or issue list. |
list |
| earliestUnreleasedUnarchivedVersion() |
Returns the name of the earliest unreleased and unarchived version. |
text |
| earliestUnreleasedVersion() |
Returns the name of the earliest unreleased version. |
text |
| epic() |
Returns all epics linked to specified issues. |
issue list |
| escapeHTML() |
Replaces special characters with HTML entities. |
text |
| except() |
Removes certain elements from a list. |
list |
| executeRemoteAction() |
Execute a JWT remote action. |
text |
| fieldChangeTimes() |
Returns the timestamps of when a field has changed satisfying a certain condition. |
number list |
| fieldHistory() |
Returns all the values a field has ever had in the past for the current issue. |
number list text list |
| fieldValue() |
Returns a number or text list with field values. |
number list text list |
| filledInTransitionScreen() |
Checks whether a selected field has has been populated on the transition screen. |
boolean |
| filterByCardinality() |
Filters a given number, text, or issue list by the number of occurence of elements. |
list |
| filterByFieldValue() |
Filters an issue list using a given comparison for field values. |
issue list |
| filterByIssueType() |
Filters a given issue list by issue type. |
issue list |
| filterByPredicate() |
Filters a number, issue, or a text list by a given logical expression. |
list |
| filterByProject() |
Filters a given issue list by project. |
issue list |
| filterByProjectCategory() |
Filters a given issue list by project category. |
issue list |
| filterByResolution() |
Filters a given issue list by resolution. |
issue list |
| filterByStatus() |
Filters a given issue list by issue status. |
issue list |
| filterByStatusCategory() |
Filters a given issue list by status category. |
issue list |
| filterByValue() |
Filters a number or text list using a given comparison. |
list |
| findModify() |
Replaces specific substrings matching a given regular expression. |
text |
| findPattern() |
Returns all substrings matching a given regular expression. |
text list |
| findPatternIgnoreCase() |
Returns all substrings matching a given regular expression, ignoring the case. |
text list |
| findReplaceAll() |
Replaces all occurrences of a given substring with the given replacement. |
text |
| findReplaceAllIgnoreCase() |
Replaces all occurrences of a given substring with a given replacement, ignoring the case. |
text |
| findReplaceFirst() |
Replaces the first occurrence of a given substring with the given replacement. |
text |
| findReplaceFirstIgnoreCase() |
Replaces the first occurrence of a given substring with the given replacement, ignoring the case. |
text |
| first() |
Returns the first element of a number, text, or issue list. |
number text issue list |
| floor() |
Returns the the next lower integer. |
number |
| formatDuration() |
Returns a duration in text form. |
text |
| formatWorkDuration() |
Returns a calculated duration using the workday and workweek defined at time tracking configuration. |
text |
| fullNameToUser() |
Returns the user name for a given user. |
text |
| getAscii() |
Returns the corresponding symbol of a given ASCII code. |
text |
| getBoolean() |
Returns a value stored in a boolean variable. |
boolean |
| getFromJSON() |
Returns the result of a given JMESPath which is applied to a JSON |
text |
| getIssueList() |
Returns values stored in an issue list variable. |
issue list |
| getIssuesFromProjects() |
Returns all issues from specified projects. |
issue list |
| getMatchingValue() |
Returns a custom reference value for a given or text or number. |
number text |
| getNumber() |
Returns a value stored in a number variable. |
number |
| getNumberList() |
Returns values stored in a number list variable. |
number list |
| getRemoteLinks() |
Returns a list of remote links. |
text list |
| getString() |
Returns the value stored in an text variable. |
text |
| getStringList() |
Returns values stored in a text list variable. |
text list |
| getUserKey() |
Returns the user key of a given user. |
text |
| groupsUserBelongsTo() |
Returns all groups for given users. |
text list |
| hasChanged() |
Returns true only if the field has changed in the current transition. |
boolean |
| hour() |
Returns the hour part of any given timestamp. |
number |
| htmlToTxt() |
Removes all HTML tags. |
text |
| indexOf() |
Returns the index / position of a specific element in a list. |
number |
| intersect() |
Returns common elements of two lists. |
list |
| invertList() |
Inverts the order of a given list. |
list |
| isAClone() |
Checks whether an issue is a clone. |
boolean |
| isActive() |
Checks whether users are active |
boolean |
| isBulkTriggeredTransition() |
Checks whether a transition was executed by a bulk operation. |
boolean |
| isInGroup() |
Checks whether users are a member of a specific group. |
boolean |
| isInRole() |
Checks whether users are a member of a specific project role. |
boolean |
| isJwtTriggeredTransition() |
Checks whether a transition was executed by a JWT post function. |
boolean |
| issueIDFromKey() |
Returns the internal ID for given issue keys. |
text |
| issueKeyFromID() |
Returns the issue key for given issue IDs. |
text |
| issueKeysToIssueList() |
Converts a text containing issue keys into an issue list. |
Issue list |
| issuesAbove() |
Returns all issues located in any level above a given parent issue according to Advanced Roadmaps hierarchy. |
issue list |
| issueSecurityLevel() |
Returns the name of the issue security level with a given ID. |
text |
| issuesFromJQL() |
Returns a list of issues returned by a specified JQL query. |
issue list |
| issuesUnder() |
Returns issues located in the level just under a given parent issue according to Advanced Roadmaps hierarchy. |
issue list |
| issuesUnderEpic() |
Returns all issues linked to a given epic |
issue list |
| issueType() |
Returns the name of the issue type with a given ID |
text |
| last() |
Returns the last element of a number, text, or issue list. |
number text issue list |
| lastAssigneeInRole() |
Returns the user name of the last assignee in a given project role. |
text |
| lastDayOfTheMonth() |
Returns the last day of the month of a given timestamp. |
number |
| lastFieldChangeTime() |
Returns the timestamp of the most recent value change of any given field. |
number |
| latestReleasedUnarchivedVersion() |
Returns the name of the latest released and unarchived version. |
text |
| latestReleasedVersion() |
Returns the name of the latest released version. |
text |
| leastBusyUserInRole() |
Returns the name of the user in a given project role with the lowest number of unresolved issues assigned. |
text |
| length() |
Returns the length any given text. |
number |
| linkedIssues() |
Returns a list of issues linked. |
issue list |
| log() |
Returns the natural logarithm of the input number. |
number |
| log10() |
Returns the base 10 logarithm of the input number. |
number |
| matches() |
Checks, if the given text matches the provided regular expression. |
boolean |
| mathOnIssueList() |
Returns a number list with results of the given calculation performed for each issue in the specified list. |
number list |
| mathOnNumberList() |
Returns a number list with results of the given calculation performed for each number in the specified list. |
number list |
| mathOnStringList() |
Returns a number list with results of the given calculation performed for each text in the specified list. |
number list |
| max() |
Returns the larger of two numeric values. |
number |
| max(list) |
Returns the highest value in a number list. |
number |
| min() |
Returns the smaller of two numeric values. |
number |
| min(list) |
Returns the smallest value in a number list. |
number |
| minute() |
Returns the minutes part of a given timestamp. |
number |
| modulus() |
Returns the remainder after division of the dividend by the divisor. |
number |
| month() |
Returns the month part of a given timestamp. |
number |
| monthToString() |
Returns the name of the month for a given timestamp. |
text |
| nextDayOfTheWeek() |
Returns a timestamp for the next occurence of any given day. |
number |
| nextTime() |
Returns the next possible timestamp based on a JWT calendar specification. |
number |
| nextUserInGroup() |
Returns the name of the next active user in a group. |
text |
| nthElement() |
Returns the nth element of a number, string or issue list. |
number text issue list |
| numberOfAvailableItems() |
Returns the number of available options of selectable fields. |
number |
| numberOfRemoteIssueLinks() |
Returns the number of issue links to remote Jira instances |
number |
| numberOfSelectedItems() |
Returns the number of selected items in a given selectable field. |
number |
| option() |
Returns the name of a custom field option. |
text |
| parent() |
Returns the direct parent(s) of the given issue(s) according to Advanced Roadmaps hierarchy. |
issue list |
| pow() |
Returns the exponentiation of two numbers. |
number |
| previousValue() |
Returns the previous value of a field for the current issue. |
text number |
| priority() |
Returns the name of the priority with a given ID. |
text |
| project() |
Returns the name of the project with a given ID. |
text |
| projectCategory() |
Returns the project category of a given project. |
text |
| projectIDFromKey() |
Returns the internal ID for given project keys. |
text |
| projectKey() |
Returns the project key from a given project. |
text |
| projectKeys() |
Returns specific project keys. |
text list |
| projectLead() |
Returns the project lead |
text |
| projectLeader() |
Returns the project lead |
text |
| projectName() |
Returns the name of a given project. |
text |
| projectProperty() |
Returns the value of a given project property. |
text |
| projectPropertyExists() |
Checks whether a project property exists. |
boolean |
| projectType() |
Returns the type of a given project. |
text |
| random() |
Returns a number between 0 and 1.0. |
number |
| releaseDates() |
Returns a number list with version release dates. |
number list |
| releasedVersions() |
Returns all released versions. |
text list |
| releasedVersionsBySequence() |
Returns all released versions sorted by default UI order. |
text list |
| remainder() |
Returns dividend - divisor * n, where n is the closest integer to dividend/divisor. |
number |
| replaceAll() |
Replaces all substrings matching a regular expression with a given replacement. |
text |
| replaceFirst() |
Replaces the first substring matching a given regular expression with a given replacement. |
text |
| resolution() |
Returns the name of the resolution with a given ID. |
text |
| rolesUserPlays() |
Returns all project roles for given users. |
text list |
| round() |
Returns the closest integer to the input number. |
number |
| second() |
Returns the second part of any given timestamp. |
number |
| setBoolean() |
Creates a variable to temporarily store a boolean value |
boolean |
| setIssueList() |
Creates a variable to temporarily store an issue list. |
issue list |
| setNumber() |
Creates a variable to temporarily store a number |
number |
| setNumberList() |
Creates a variable to temporarily store a number list. |
number list |
| setString() |
Creates a variable to temporarily store a text. |
text |
| setStringList() |
Creates a variable to temporarily store a text list. |
text list |
| shortFormatDuration() |
Returns a duration in short text form. |
text |
| shortFormatWorkDuration() |
Returns a calculated duration using the workday and workweek defined at time tracking configuration in a comprehensive form. |
text |
| siblingIssues() |
Returns all issues which are located directly under a given issue's parent according to Advanced Roadmaps hierarchy. |
issue list |
| siblingIssuesUnderEpic() |
Returns all sibling issues linked to the same epic |
issue list |
| siblingSubtasks() |
Returns all sibling sub-tasks. |
issue list |
| similarity() |
Calculates the similarity between two texts. |
number |
| sin() |
Returns the trigonometric sine of angle number expressed in radians. |
number |
| sinh() |
Returns the hyperbolic sine of the input number. |
number |
| sort() |
Sorts a given list in a specific order. |
list |
| sqrt() |
Returns the square root of the input number. |
number |
| startDates() |
Returns a number list with version start dates. |
number list |
| status() |
Returns a status name. |
text |
| stringToDate() |
Converts a text into a date. |
number |
| sublist() |
Returns a defined extract of a given list. |
list |
| substring() |
Returns a specific part of a text. |
text |
| subtasks() |
Returns sub-tasks of given issues. |
issue list |
| subtractDatesSkippingWeekends() |
Subtracts two timestamps ignoring the weekends. |
number |
| sum() |
Sums up all values in a given number list. |
number |
| tan() |
Returns the trigonometric tangent of angle number expressed in radians. |
number |
| tanh() |
Returns the hyperbolic tangent of the input number. |
number |
| textOnIssueList() |
Returns a text list in result of evaluating textExpression against each of the issues in argument issues. |
text list |
| textOnNumberList() |
Returns a text list in a result of evaluating text_expression against each of the numeric values in argument numbers. |
text list |
| textOnStringList() |
Matches elements of a text list against a text expression. |
text list |
| timeDifference() |
Subtracts two timestamps based on a JWT calendar specification |
number |
| timeInStatus() |
Returns the time the current issue has remained in a specific status. |
number |
| timeInValue() |
Returns the time an issue field has had a specific value. |
number |
| timeLogged() |
Returns the sum of all the time logged on issues. |
number |
| timePart() |
Returns the time part of any given date. |
number |
| timesOfTransition() |
Returns the timestamps of when a certain transition was executed. |
number list |
| timeZone() |
Returns a time zone. |
time zone |
| toDegree() |
Converts an angle measured in radians to an approximately equivalent angle measured in degrees. |
number |
| toInteger() |
Converts text into an integer. |
number |
| toLowerCase() |
Converts a given text with all its characters lower case. |
text |
| toNumber() |
Converts text into a number. |
number |
| toNumberList() |
Converts text containing numbers into a number list. |
number list |
| toRadians() |
Converts an angle measured in degrees to an approximately equivalent angle measured in radians. |
number |
| toString() |
Converts numbers and lists into plain text. |
text |
| toStringList() |
Converts text into a text list. |
text list |
| toUpperCase() |
Converts a given text with all characters to upper case. |
text |
| transitionLinkedIssues() |
Returns a list of all issues linked during the transition. |
issue list |
| transitivelyLinkedIssues() |
Returns issues that are directly or transitively linked to the current issue. |
issue list |
| trim() |
Removes leading and trailing blanks (white spaces and tabs) from a text. |
text |
| unescapeHTML() |
Replaces HTML escapes with their corresponding Unicode characters. |
text |
| union() |
Returns distinct elements of two lists. |
list |
| unreleasedVersions() |
Returns all unreleased versions. |
text list |
| unreleasedVersionsBySequence() |
Returns all unreleased versions sorted by default UI order |
text list |
| userDisplayName() |
Returns the full name of a given user. |
text text list |
| userEmail() |
Returns the email address(es) of given users. |
text text list |
| userFullName() |
Returns the full name of a given user. |
text text list |
| userProperty() |
Returns the values of user properties. |
text |
| usersInGroup() |
Returns the user names of active users in a given group. |
text list |
| usersInRole() |
Returns members of a given project role. |
text list |
| usersWhoTransitioned() |
Returns the names of the users who executed a certain transition. |
text list |
| usersWithEmail() |
Returns the user names of users matching a given email address. |
text list |
| weekOfTheYear() |
Returns the week of a year. |
number |
| wikiToHTML() |
Converts rich text wiki content to HTML. |
text |
| withinCalendar() |
Checks whether a timestamp falls into a time frame defined in a JWT calendar specification. |
boolean |
| year() |
Returns the year part of a timestamp. |
number |