Is there a way to filter 'Linked Issues' column to show only "is blocked by" / "blocks" relation

Marko Airisto
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 7, 2024

Hi,

New here and I'm not a coder so please bare with me.

I'm trying to create a Structure to show in a column if some of our Features have dependencies with other Features (marked with 'blocks' and/or 'is blocked by' relation).

So far, I've extended my Structure with Linked Issues extender (Link type: Blocks, Link direction: parent issues is blocked by or blocks sub-issue), and I've also added a JQL filter with issueLinkType in (blocks, "is blocked by").

01.PNG

After comparing my JIRA query and the list now in Structure, these actions give me the correct number & list of Features in my project that have issues with either 'is blocked by', 'blocks' or with both relations mentioned in their Linked issues section.

Next step would be to add a view to see if the Features mentioned in the Structure are providers or receivers when it comes to dependencies. For that I thought of adding the 'Linked Issues' column that already exists, the one with this formula:

/* 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))))

Now, the problem / question is, how can I filter the results of this formula query to only show 'blocks' and 'is blocked by' relations and their respective issue links in the column?

02.PNG

And secondary question is, can I edit the 'Linked Issues' column formula without causing changes to everyone else in the company using the same column in their own Structures, or should I copy the column / formula somehow and make changes to the copied column / formula? I've tried to duplicate the formula already few times, but for some reason my version doesn't show any linked issues even though the formulas are identical.

2 answers

1 accepted

0 votes
Answer accepted
Stepan Kholodov _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 7, 2024

Hello @Marko Airisto 

You can change the formula this way:

/* 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
.FILTER($.type = "blocks")
.GROUP(IF $.source.key = key: $.type.outward ELSE : $.type.inward)
.MAP(CONCAT($.group, " ", $.elements.
MAP(IF $.source.key = key :markdown($.destination) ELSE :markdown($.source))))

And as long as you don't save the existing view of the structure after changing the formula, other users won't see the updated formula and its results.

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

Marko Airisto
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 7, 2024

Works perfectly now! Thank You so much!

Like Stepan Kholodov _Tempo_ likes this
0 votes
Prajakta Kolhe
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 29, 2024

The above formula doesnt work for depends on or is neeed by link. Can you share the formula for depends on and is needed by link 

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events