Sample Formulas - Items and Properties

Access an item property

Use the following format: item.property

The following returns the release date for each fix version:

CODE

fixVersions.releaseDate

Note: if the fix version field contained multiple values, multiple dates will be returned.

For a list of accessible item types and their properties, see Item Property Reference.

Get a custom field value for this issue, its epic, or its sub-task

You can accomplish this in a few different ways:

CODE

this.storypoints   // Using item properties. Use a lowercased custom field name, with spaces skipped.
this.ACCESS("Story Points") // Using the ACCESS function. Write the custom field exactly as it appears in Jira (with spaces).
this.customfield_###### // Using the custom field's id.

See how many sprints an issue has been added to

CODE

sprint.size()

Find the highest subtask priority

CODE

subtasks.priority.UMAX()

Returns the highest priority of the subtasks.

Find the subtask with the highest priority

CODE

with highest_priority = subtasks.priority.UMAX(): subtasks.FILTER($.priority = highest_priority)

Returns all subtasks with the highest priority.

Compare two priorities

CODE

IF(priority1.sequence > priority2.sequence)

Predict the finish date for epics

CODE

IF issueType = epic : 
  MAX(epicStories.sprint.endDate)

Returns the latest sprint end date for stories within each epic, even if those stories are not contained in the structure.