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

Question

This seems like an easy and common requirement.

Cloud.

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.

Marijn Plat_uvj022 · Answer

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

Marijn Plat_uvj022 · Answer

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"

Stepan Kholodov · Answer

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
Tempo