How to create a Column in Jira Structure to show only LInked Issues to a Particular Jira Project

[Laura Pellizzari]

How to create a Column in Jira Structure to show only LInked Issues to a Particular Jira Project

the current formula for linked issues in Structure is the following:

/* Displays all linked issues and the link types using markdown language.

  */

WITH markdown(issue) = CONCAT(

  "[", IF issue.status.category == "Done": "~", issue.key,

  IF issue.status.category == "Done": "~", "](", issue.url, ")"

):

issueLinks

  .GROUP(IF $.source.key = key: $.type.outward ELSE : $.type.inward)

  .MAP(CONCAT($.group, " ", $.elements.MAP(IF $.source.key = key :markdown($.destination) ELSE :markdown($.source))))

Anyone can help?

thanks

Laura

[Gor Greyan]

Hi @Laura Pellizzari

I think you should filter the link collection before you group/map it, keeping only links where the “other side” of the link belongs to your target project. Try the following one.

WITH markdown(issue) =
CONCAT("[", IF issue.status.category = "Done": "~", issue.key,
IF issue.status.category = "Done": "~", "](", issue.url, ")"),

other(link) =
IF link.source.key = key : link.destination ELSE : link.source
:

issueLinks

.FILTER(other($).project.key = "ABC")

.GROUP(IF $.source.key = key : $.type.outward ELSE : $.type.inward)

.MAP(CONCAT($.group, " ", $.elements.MAP(markdown(other($)))))