Jira Workflow Toolbox for Jira Cloud uses a powerful expression parser for interpreting logical, mathematical, date-time and text functions.
Function areas
📚 Expression parser function library
| Function name | Short description | Output |
|---|---|---|
| abs(number) |
Returns the absolute value of the input number. |
number |
| addDays() |
Adds or subtracts days to or from any given date. |
number |
| append() |
Combines the elements of two lists. |
number list text list issue list |
| avg() |
Calculates the average values of a given number list. |
number |
| ceil(number) |
Returns the smallest mathematical integer that is greater than or equal to 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 date. |
number |
| dateTimeToString() |
Returns the timestamp of any given date in text form. |
text |
| dateToString() |
Converts any given date to a text. |
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 |
| distinct() |
Removes all duplicates from a number, text, or issue list. |
number list text list issue list |
| epic() |
Returns all epics linked to specified issues. |
issue list |
| except() |
Removes certain elements from a list. |
number list text list issue list |
| fieldValue() |
Returns a number or text list with field values. |
number list text list |
| filterByCardinality() |
Filters a given number, text, or issue list by the number of occurrence of elements. |
number list text list issue list |
| filterByIssueType() |
Filters a given issue list by issue type. |
issue list |
| filterByProject() |
Filters a given issue list by project. |
issue list |
| filterByResolution() |
Filters a given issue list by resolution. |
issue list |
| filterByStatus() |
Filters a given issue list by issue status. |
issue list |
| filterByValue() |
Filters a number or text list using a given comparison. |
number list text list |
| 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 text with the given replacement. |
text |
| findReplaceAllIgnoreCase() |
Replaces all occurrences of a given text with a given replacement, ignoring the case. |
text |
| findReplaceFirst() |
Replaces the first occurrence of a given text with the given replacement. |
text |
| findReplaceFirstIgnoreCase() |
Replaces the first occurrence of a given text 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 greatest mathematical integer that is less than or equal to the input number. |
number |
| getAssetsFromAQL() |
Returns the Asset object key(s) of a given AQL expression. |
text list |
| getAttributeFromAsset() |
Returns the Asset object attribute value(s) of a given asset. |
text text LIST |
| getFromJSON() |
Returns the result of a given JMESPath which is applied to a JSON |
text |
| getMatchingValue() |
Returns a custom reference value for a given or text or number. |
number text |
| getNameFromAsset() |
Returns the Asset object names(s) of given asset(s). |
text list |
| groupName() |
Returns the name of given group ID(s). |
text list |
| hour() |
Returns the hour part of any given timestamp. |
number |
| intersect() |
Returns common elements of two lists. |
number list text list issue list |
| 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 |
| issueKeysToIssueList() |
Converts a text containing issue keys to an issue list. |
Issue list |
| issuesFromJQL() |
Returns a list of issues returned by a specified JQL query. |
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 |
| jiraExpression() |
Returns the result of a Jira expression. |
text |
| last() |
Returns the last element of a number, text, or issue list. |
number text issue list |
| length() |
Returns the length any given text. |
number |
| linkedIssues() |
Returns a list of issues linked. |
issue list |
| matches() |
Checks, if the given text matches the given regular expression. |
boolean |
| max() |
Returns the highest value in a number list. |
number |
| max(numbers) |
Returns the larger of two numeric values. |
number |
| min() |
Returns the smallest value in a number list. |
number |
| min(numbers) |
Returns the smaller of two numeric values. |
number |
| minute() |
Returns the minutes part of a given timestamp. |
number |
| modulus(numbers) |
Returns the remainder after division of the dividend by the divisor. |
number |
| month() |
Returns the month part of a given timestamp. |
number |
| nthElement() |
Returns the nth element of a number, text or issue list. |
number text issue list |
| organizationId() |
Returns the Organization ID of a given organization(s). |
text list |
| parent() |
Returns the direct parent(s) of the given issue(s) according to configured hierarchy. |
issue list |
| project() |
Returns the key of the project with a given ID. |
text |
| projectId() |
Returns the ID of the project with a given key or name. |
number |
| random() |
Returns a number between 0 and 1.0. |
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 |
| round(number) |
Returns the closest integer to the input number. |
number |
| second() |
Returns the second part of a given timestamp. |
number |
| siblingIssuesUnderEpic() |
Returns all issues linked to a given epic |
issue list |
| sort() |
Sorts a given list in a specific order. |
number list text list issue list |
| status() |
Returns a status name. |
text |
| stringToDate() |
Converts a text into a date. |
number |
| sublist() |
Returns a defined extract of a given list. |
number list text list issue list |
| substring() |
Returns a specific part of a text. |
text |
| subtasks() |
Returns the list of sub-tasks of the specified issue(s). |
issue list |
| sum() |
Sums up all values in a given number list. |
number |
| timePart() |
Returns the time part of any given date. |
number |
| toLogicalValue() |
Converts a text and lists to a logical value. |
boolean |
| toLowerCase() |
Converts a given text with all its characters to lower case. |
text |
| toNumber() |
Converts a text to a number. |
number |
| toNumberList() |
Converts text to a number list. |
number list |
| toString() |
Converts numbers and lists to plain text. |
text |
| toStringList() |
Converts text to a text list. |
text list |
| toUpperCase() |
Converts a given text with all characters to upper case. |
text |
| trim() |
Removes leading and trailing blanks (white spaces and tabs) from a text. |
text |
| union() |
Returns distinct elements of two lists. |
number list text list issue list |
| userAccountId() |
Returns the Atlassian account Id of given user(s). |
text |
| userAccountIdAY() |
Returns the Atlassian account Id of given user(s). |
text |
| userDisplayName() |
Returns the display name of a given user. |
text |
| usersInOrganization() |
Returns the Atlassian account ID of a given Organization ID(s). |
text list |
| year() |
Returns the year part of a timestamp. |
number |