Skip to main content
Skip table of contents

Sample Formulas - Issue Links and Subtasks

Show linked issues

Displays issues linked to the current issue.

CODE
issueLinks.MAP(IF($.source = this, $.destination, $.source))

Displays issue links containing the current issue. Ex. STR-006 → GANTT-002

CODE
issueLinks.MAP($.source.key CONCAT '→' CONCAT $.destination.key)

Show issues blocking the current issue

Displays issue links for all blockers.

CODE
WITH _format(issue) = """[${issue.key}|${issue.url}]""" :
issuelinks
  .FILTER($.type = 'Blocks' AND $.destination = this)
  .MAP(_format($.source))

Make sure to set the column Options to Wiki Markup.

Want to display another link type? Change: $.type = 'Blocks'

Check whether all blocking issues are resolved

Displays "OK" if all issues linked via the "Blocks" link type are marked as resolved.

CODE
IF issueLinks.FILTER($.type = "Blocks" AND $.destination = this).ALL($.source.resolution):
   "OK"

Show parent issue

Displays the parent issue of the current item, based on the "is parent of" link.

Depending on the direction of your parent links, select one of the following:

Outward parent links

CODE
issueLinks.FILTER($.type.outward = "is parent of" AND $.destination = this).MAP($.source.key CONCAT ' - ' CONCAT $.source.summary)

or

Inward parent links

CODE
issueLinks.FILTER($.type.inward = "is parent of" AND $.destination = this).MAP($.source.key CONCAT ' - ' CONCAT $.source.summary)

Show percent of subtasks that have been completed

CODE
IF subtasks.SIZE() > 0 :

    subtasks.FILTER($.status = ‘Done’).SIZE() / subtasks.SIZE()
JavaScript errors detected

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

If this problem persists, please contact our support.