Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.