Jira Workflow Toolbox uses powerful parser expressions for interpreting logical, mathematical, date-time, and text terms.
The following is a list of the available expression parser function categories:
All available parser functions
| Function name | Short description | Output | Available since |
|---|---|---|---|
| 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 | NEEDS LOOKUP |
| addDaysSkippingWeekends() | Adds or subtracts natural days (or working days) to or from any given date. | NUMBER | 2.2.7 |
| 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 | NEEDS LOOKUP |
| addTimeSkippingWeekends() | Adds or subtracts time to or from any given date. | NUMBER | 2.2.7 |
| addYears() | Adds or subtracts years to or from any given date. | NUMBER | |
| allAvailableItems() | This function returns all available options of selectable fields. | TEXT LIST | 2.2.7 |
| allCommentCreators() | Returns all comment creators | TEXT LIST | NEEDS LOOKUP |
| allCommentDates() | Returns the dates of specified comments | NUMBER LIST | NEEDS LOOKUP |
| allCommenters() | Returns all comment authors and updaters | TEXT LIST | 2.2.9 |
| allComments() | Returns defined comments | TEXT LIST | NEEDS LOOKUP |
| allIssuesUnder() | Returns issues located in any level under a given parent issue according to Advanced Roadmaps hierarchy. | ISSUE LIST | 3.1.0 |
| append() | Combines the elements of two lists. | LIST | 2.1.21 |
| archivedVersions() | Returns all archived versions. | TEXT LIST | NEEDS LOOKUP |
| 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 | 2.4.8 |
| availableItems() | Returns available options of selectable fields - disabled options will be ignored. | TEXT LIST | 2.2.7 |
| avg() | Calculates the average values of a given number list. | NUMBER | NEEDS LOOKUP |
| capitalizeWords() | Capitalizes a text, only updating the first letters. | TEXT | 2.1.34 |
| capitalizeWordsFully() | Capitalizes an entire text. | TEXT | 2.1.34 |
| 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 | 2.2.36 |
| componentLeads() | Returns the user name(s) of specified component leads | TEXT | 3.0.1 |
| 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 | 2.1.32 |
| datePart() | Returns the date part of any given timestamp. | NUMBER | |
| dateTime() | Creates a timestamp based on input values. | NUMBER | 2.3.3 |
| dateTimeToString() | Returns the timestamp of any given date in text form. | TEXT | 2.4.0 |
| 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 | 2.6.0 |
| daysInTheMonth() | Returns the number of days in a month of any given timestamp. | NUMBER | 2.3.3 |
| defaultUserForRole() | Returns the user name of the default project role user. | TEXT | 2.2.8 |
| displayNameToUser() | Returns the user name for a given user. | TEXT | 3.0.1 |
| distinct() | Removes all duplicates from a number, text, or issue list. | LIST | 2.1.21 |
| earliestUnreleasedUnarchivedVersion() | Returns the name of the earliest unreleased and unarchived version. | TEXT | 2.3.0 |
| earliestUnreleasedVersion() | Returns the name of the earliest unreleased version. | TEXT | NEEDS LOOKUP |
| epic() | Returns all epics linked to specified issues. | ISSUE LIST | 2.3.0 |
| escapeHTML() | Replaces special characters with HTML entities. | TEXT | 2.2.30 |
| except() | Removes certain elements from a list. | LIST | 2.1.21 |
| 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 | 2.2.7 |
| filterByCardinality() | Filters a given number, text, or issue list by the number of occurence of elements. | LIST | NEEDS LOOKUP |
| filterByFieldValue() | Filters an issue list using a given comparison for field values. | ISSUE LIST | 2.1.21 |
| filterByIssueType() | Filters a given issue list by issue type. | ISSUE LIST | NEEDS LOOKUP |
| filterByPredicate() | Filters a number, issue, or a text list by a given logical expression. | LIST | 2.1.32 |
| filterByProject() | Filters a given issue list by project. | ISSUE LIST | NEEDS LOOKUP |
| filterByProjectCategory() | Filters a given issue list by project category. | ISSUE LIST | 2.1.33 |
| filterByResolution() | Filters a given issue list by resolution. | ISSUE LIST | NEEDS LOOKUP |
| filterByStatus() | Filters a given issue list by issue status. | ISSUE LIST | NEEDS LOOKUP |
| filterByStatusCategory() | Filters a given issue list by status category. | ISSUE LIST | 2.1.33 |
| filterByValue() | Filters a number or text list using a given comparison. | LIST | 2.1.23 |
| findModify() | Replaces specific substrings matching a given regular expression. | TEXT | 2.2.12 |
| findPattern() | Returns all substrings matching a given regular expression. | TEXT LIST | 2.1.32 |
| findPatternIgnoreCase() | Returns all substrings matching a given regular expression, ignoring the case. | TEXT LIST | 2.1.32 |
| findReplaceAll() | Replaces all occurrences of a given substring with the given replacement. | TEXT | 2.1.32 |
| findReplaceAllIgnoreCase() | Replaces all occurrences of a given substring with a given replacement, ignoring the case. | TEXT | 2.1.32 |
| findReplaceFirst() | Replaces the first occurrence of a given substring with the given replacement. | TEXT | 2.1.32 |
| findReplaceFirstIgnoreCase() | Replaces the first occurrence of a given substring with the given replacement, ignoring the case. | TEXT | 2.1.32 |
| first() | Returns the first element of a number, text, or issue list. | NUMBER TEXT ISSUE LIST | 2.1.26 |
| 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 | 2.2.34 |
| fullNameToUser() | Returns the user name for a given user. | TEXT | 2.1.32 |
| getAscii() | Returns the corresponding symbol of a given ASCII code. | TEXT | 2.2.12 |
| getBoolean() | Returns a value stored in a boolean variable. | BOOLEAN | 2.6.0 |
| 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 | 2.6.0 |
| getIssuesFromProjects() | Returns all issues from specified projects. | ISSUE LIST | 2.1.21 |
| getMatchingValue() | Returns a custom reference value for a given or text or number. | NUMBER TEXT | 2.2.25 |
| getNumber() | Returns a value stored in a number variable. | NUMBER | 2.6.0 |
| getNumberList() | Returns values stored in a number list variable. | NUMBER LIST | 2.6.0 |
| getRemoteLinks() | Returns a list of remote links. | TEXT LIST | 3.3.0 |
| getString() | Returns the value stored in an text variable. | TEXT | 2.6.0 |
| getStringList() | Returns values stored in a text list variable. | TEXT LIST | 2.6.0 |
| getUserKey() | Returns the user key of a given user. | TEXT | 3.0.1 |
| groupsUserBelongsTo() | Returns all groups for given users. | TEXT LIST | 2.1.32 |
| hasChanged() | Returns true only if the field has changed in the current transition. | BOOLEAN | NEEDS LOOKUP |
| hour() | Returns the hour part of any given timestamp. | NUMBER | |
| htmlToTxt() | Removes all HTML tags. | TEXT | 2.4.0 |
| indexOf() | Returns the index / position of a specific element in a list. | NUMBER | 2.1.29 |
| intersect() | Returns common elements of two lists. | LIST | 2.1.21 |
| invertList() | Inverts the order of a given list. | LIST | 2.5.0 |
| isAClone() | Checks whether an issue is a clone. | BOOLEAN | 2.1.27 |
| isActive() | Checks whether users are active | BOOLEAN | |
| isBulkTriggeredTransition() | Checks whether a transition was executed by a bulk operation. | BOOLEAN | 2.2.12 |
| 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 | 2.1.27 |
| issueIDFromKey() | Returns the internal ID for given issue keys. | TEXT | 2.2.39 |
| issueKeyFromID() | Returns the issue key for given issue IDs. | TEXT | 2.2.39 |
| 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 | 3.1.0 |
| issueSecurityLevel() | Returns the name of the issue security level with a given ID. | TEXT | 2.5.0 |
| issuesFromJQL() | Returns a list of issues returned by a specified JQL query. | ISSUE LIST | 2.1.33 |
| issuesUnder() | Returns issues located in the level just under a given parent issue according to Advanced Roadmaps hierarchy. | ISSUE LIST | 3.1.0 |
| issuesUnderEpic() | Returns all issues linked to a given epic | ISSUE LIST | 2.3.0 |
| issueType() | Returns the name of the issue type with a given ID | TEXT | 2.5.0 |
| last() | Returns the last element of a number, text, or issue list. | NUMBER TEXT ISSUE LIST | 2.1.26 |
| lastAssigneeInRole() | Returns the user name of the last assignee in a given project role. | TEXT | 2.2.8 |
| lastDayOfTheMonth() | Returns the last day of the month of a given timestamp. | NUMBER | 2.3.3 |
| lastFieldChangeTime() | Returns the timestamp of the most recent value change of any given field. | NUMBER | 2.6.0 |
| latestReleasedUnarchivedVersion() | Returns the name of the latest released and unarchived version. | TEXT | 2.3.0 |
| latestReleasedVersion() | Returns the name of the latest released version. | TEXT | NEEDS LOOKUP |
| leastBusyUserInRole() | Returns the name of the user in a given project role with the lowest number of unresolved issues assigned. | TEXT | 2.2.33 |
| length() | Returns the length any given text. | NUMBER | NEEDS LOOKUP |
| linkedIssues() | Returns a list of issues linked. | ISSUE LIST | NEEDS LOOKUP |
| log10() | Returns the base 10 logarithm of the input number. | NUMBER | |
| log() | Returns the natural logarithm of the input number. | NUMBER | |
| matches() | Checks, if the given text matches the provided regular expression. | BOOLEAN | NEEDS LOOK UP |
| mathOnIssueList() | Returns a number list with results of the given calculation performed for each issue in the specified list. | NUMBER LIST | 2.2.2 |
| mathOnNumberList() | Returns a number list with results of the given calculation performed for each number in the specified list. | NUMBER LIST | 2.2.8 |
| mathOnStringList() | Returns a number list with results of the given calculation performed for each text in the specified list. | NUMBER LIST | 2.2.8 |
| max() | Returns the larger of two numeric values. | NUMBER | |
| max(list) | Returns the highest value in a number list. | NUMBER | NEEDS LOOKUP |
| min() | Returns the smaller of two numeric values. | NUMBER | |
| min(list) | Returns the smallest value in a number list. | NUMBER | NEEDS LOOKUP |
| 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 | 2.3.3 |
| nextTime() | Returns the next possible timestamp based on a JWT calendar specification. | NUMBER | NEEDS LOOKUP |
| nextUserInGroup() | Returns the name of the next active user in a group. | TEXT | 2.2.33 |
| nthElement() | Returns the nth element of a number, string or issue list. | NUMBER TEXT ISSUE LIST | 2.1.27 |
| numberOfAvailableItems() | Returns the number of available options of selectable fields. | NUMBER | 2.2.7 |
| numberOfRemoteIssueLinks() | Returns the number of issue links to remote Jira instances | NUMBER | NEEDS LOOKUP |
| numberOfSelectedItems() | Returns the number of selected items in a given selectable field. | NUMBER | 2.2.7 |
| option() | Returns the name of a custom field option. | TEXT | 2.5.0 |
| parent() | Returns the direct parent(s) of the given issue(s) according to Advanced Roadmaps hierarchy. | ISSUE LIST | 3.1.0 |
| 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 | 2.5.0 |
| project() | Returns the name of the project with a given ID. | TEXT | 2.5.0 |
| projectCategory() | Returns the project category of a given project. | TEXT | 2.4.0 |
| projectIDFromKey() | Returns the internal ID for given project keys. | TEXT | 2.9.3 |
| projectKey() | Returns the project key from a given project. | TEXT | 2.4.9 |
| projectKeys() | Returns specific project keys. | TEXT LIST | 2.4.0 |
| projectLead() | Returns the project lead | TEXT | 3.0.1 |
| projectLeader() | Returns the project lead | TEXT | 2.5.0 |
| projectName() | Returns the name of a given project. | TEXT | 2.4.0 |
| projectProperty() | Returns the value of a given project property. | TEXT | 2.2.8 |
| projectPropertyExists() | Checks whether a project property exists. | BOOLEAN | 2.2 |
| projectType() | Returns the type of a given project. | TEXT | 3.0.1 |
| random() | Returns a number between 0 and 1.0. | NUMBER | |
| releaseDates() | Returns a number list with version release dates. | NUMBER LIST | 2.2.38 |
| releasedVersions() | Returns all released versions. | TEXT LIST | NEEDS LOOKUP |
| releasedVersionsBySequence() | Returns all released versions sorted by default UI order. | TEXT LIST | NEEDS LOOKUP |
| 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 | NEEDS LOOKUP |
| replaceFirst() | Replaces the first substring matching a given regular expression with a given replacement. | TEXT | NEEDS LOOKUP |
| resolution() | Returns the name of the resolution with a given ID. | TEXT | 2.5.0 |
| rolesUserPlays() | Returns all project roles for given users. | TEXT LIST | 2.2.20 |
| 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 | 2.6.0 |
| setIssueList() | Creates a variable to temporarily store an issue list. | ISSUE LIST | 2.6.0 |
| setNumber() | Creates a variable to temporarily store a number | NUMBER | 2.6.0 |
| setNumberList() | Creates a variable to temporarily store a number list. | NUMBER LIST | 2.6.0 |
| setString() | Creates a variable to temporarily store a text. | TEXT | 2.6.0 |
| setStringList() | Creates a variable to temporarily store a text list. | TEXT LIST | 2.6.0 |
| shortFormatDuration() | Returns a duration in short text form. | TEXT | 2.2.30 |
| shortFormatWorkDuration() | Returns a calculated duration using the workday and workweek defined at time tracking configuration in a comprehensive form. | TEXT | NEEDS LOOKUP |
| siblingIssues() | Returns all issues which are located directly under a given issue's parent according to Advanced Roadmaps hierarchy. | ISSUE LIST | 3.1.0 |
| siblingIssuesUnderEpic() | Returns all sibling issues linked to the same epic | ISSUE LIST | 2.3.0 |
| siblingSubtasks() | Returns all sibling sub-tasks. | ISSUE LIST | 2.2.1 |
| similarity() | Calculates the similarity between two texts. | NUMBER | 2.2.29 |
| 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 | 2.1.27 |
| sqrt() | Returns the square root of the input number. | NUMBER | |
| startDates() | Returns a number list with version start dates. | NUMBER LIST | 2.2.38 |
| status() | Returns a status name. | TEXT | 2.5.0 |
| stringToDate() | Converts a text into a date. | NUMBER | 2.2.29 |
| sublist() | Returns a defined extract of a given list. | LIST | 2.1.29 |
| substring() | Returns a specific part of a text. | TEXT | NEEDS LOOKUP |
| subtasks() | Returns sub-tasks of given issues. | ISSUE LIST | NEEDS LOOKUP |
| subtractDatesSkippingWeekends() | Subtracts two timestamps ignoring the weekends. | NUMBER | 2.2.7 |
| sum() | Sums up all values in a given number list. | NUMBER | NEEDS LOOKUP |
| 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 | 2.2.2 |
| textOnNumberList() | Returns a text list in a result of evaluating text_expression against each of the numeric values in argument numbers. | TEXT LIST | 2.2.8 |
| textOnNumberList() | |||
| textOnStringList() | Matches elements of a text list against a text expression. | TEXT LIST | 2.2.8 |
| timeDifference() | Subtracts two timestamps based on a JWT calendar specification. | NUMBER | 2.2.39 |
| timeInStatus() | Returns the time the current issue has remained in a specific status. | NUMBER | NEEDS LOOKUP |
| timeInValue() | Returns the time an issue field has had a specific value. | NUMBER | NEEDS LOOKUP |
| timeLogged() | Returns the sum of all the time logged on issues. | NUMBER | NEEDS LOOKUP |
| timePart() | Returns the time part of any given date. | NUMBER | |
| timesOfTransition() | Returns the timestamps of when a certain transition was executed. | NUMBER LIST | 2.2.7 |
| timeZone() | Returns a time zone. | TIME ZONE | 2.2.39 |
| 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 | NEEDS LOOKUP |
| 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 | NEEDS LOOKUP |
| transitionLinkedIssues() | Returns a list of all issues linked during the transition. | ISSUE LIST | 2.1.21 |
| transitivelyLinkedIssues() | Returns issues that are directly or transitively linked to the current issue. | ISSUE LIST | 2.1.22 |
| trim() | Removes leading and trailing blanks (white spaces and tabs) from a text. | TEXT | NEEDS LOOKUP |
| unescapeHTML() | Replaces HTML escapes with their corresponding Unicode characters. | TEXT | 2.2.30 |
| union() | Returns distinct elements of two lists. | LIST | 2.1.21 |
| unreleasedVersions() | Returns all unreleased versions. | TEXT LIST | NEEDS LOOKUP |
| unreleasedVersionsBySequence() | Returns all unreleased versions sorted by default UI order | TEXT LIST | NEEDS LOOKUP |
| userDisplayName() | Returns the full name of a given user. | TEXT TEXT LIST | 3.0.1 |
| userEmail() | Returns the email address(es) of given users. | TEXT TEXT LIST | 2.2.29 |
| userFullName() | Returns the full name of a given user. | TEXT TEXT LIST | 2.1.26 |
| userProperty() | Returns the values of user properties. | TEXT | 2.1.34 |
| usersInGroup() | Returns the user names of active users in a given group. | TEXT LIST | 2.2.8 |
| usersInRole() | Returns members of a given project role. | TEXT LIST | 2.2.8 |
| usersWhoTransitioned() | Returns the names of the users who executed a certain transition. | TEXT LIST | 2.2.7 |
| usersWithEmail() | Returns the user names of users matching a given email address. | TEXT LIST | 2.1.32 |
| weekOfTheYear() | Returns the week of a year. | NUMBER | 2.6.0 |
| wikiToHTML() | Converts rich text wiki content to HTML. | TEXT | 2.2.32 |
| withinCalendar() | Checks whether a timestamp falls into a time frame defined in a JWT calendar specification. | BOOLEAN | NEEDS LOOKUP |
| year() | Returns the year part of a timestamp. | NUMBER |
