Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Structure formula column to show linkedissues of certain linkage type and issuetype


This seems like an easy and common requirement.


For any row (epic), I want to see directly in a formula column if the row has certain issuetypes linked to it through the 'implements' linkage (if yes, then return 'yes').

For example, I have an epic which implements an IT-application issuetype.


these linkages are not considered children, so MAX#children or any alternatives won't work. The vast amount of solutions I'm finding online are for JQL queries, like LinkedIssues() but I just can't seem to get that to work in Structure's formula functionality.

1 answer

1 vote
Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Nov 07, 2023

Hello @Marijn Plat 

The MAX#children function indeed won't work because aggregate functions only work for hierarchies that are represented in the structure. I.e. you would need to have all linked issues present there for the function to be able to consider their values.

To consider linked issues that are not added to the structure, you would need to use the issueLinks() function which can access linked issues and their values. You can use a formula like this for checking if an Epic has any It-application type issues linked to it with the 'implements' link:

if issuelinks.filter($.type = "implements").destination.filter($.issuetype = "IT-application").size() > 0: "true"

You might need to change destination to source, depending on the inward/outward direction of the link.

I hope this helps. If you have more questions, please reach out to us directly at our support portal.

Best regards,
Stepan Kholodov

Hey Stepan,

thanks for your quick reply. It does not return anything in my columns yet, despite also trying with changing destination to source.

Using this exact formula:

if issuelinks.filter($.type = "implements").source.filter($.issuetype = "Legacy IT Application").size() > 0: "true"

2023-11-07 13_28_03-Structure - Jira — Mozilla Firefox.png2023-11-07 13_29_44-Structure - Jira — Mozilla Firefox.png

Hey Stepan, do you have any new ideas for me on how to realise this?

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events