Sample Formulas - Issue Links and Subtasks

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)

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'

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"

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:

CODE

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

or

CODE

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

CODE

IF subtasks.SIZE() > 0 :

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