nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Laura Pellizzari

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

Accepted answers

Stepan Kholodov

Hello @Laura Pellizzari @Gor Greyan

Please note - currently, the Formula column can't access the Project field via the issueLinks function. This is why the formulas you're trying return empty results. You can find the list of available properties that can be extracted via issuelinks in our documentation here.

We have a feature request to expand the list of available attributes in the future, and Project will be among them.

If you have any other questions about Structure, please contact us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

All comments

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($)))))

Laura Pellizzari

Hi @Gor Greyan

thanks for your support, can you please suggest how to correctly accomodate the central part:

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

mark down.jpg when added the system does not recognize the variable anymore and it does not give any result.

thanks a lot

Laura

Gor Greyan

Hi @Laura Pellizzari

Thanks for the follow up:

Please try this one

WITH markdown(issue) =
CONCAT(
"[",
IF issue.status.category = "Done" : "~", issue.key,
IF issue.status.category = "Done" : "~", "](", issue.url, ")"
),
/* Return the issue on the “other side” of a link */
other(link) =
IF link.source.key = key : link.destination ELSE : link.source
:
workItemLinks
.FILTER(other($).project.key = "ABC")
.GROUP(IF $.source.key = key : $.type.outward ELSE : $.type.inward)
.MAP(CONCAT($.group, " ", $.elements.MAP(markdown(other($)))))

If you prefer to filter by project name instead of key, change the filter line to:

<span> .FILTER(other($).project.name = "My Project Name")</span>

Laura Pellizzari

Thanks, please have a look to the screenshot, I think the problem is in the middle part:

mark down 2.jpg

Stepan Kholodov

Laura Pellizzari

thanks a lot.

Laura

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

structure

tempo