You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Join now to unlock these features and more
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.
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.
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"