Use column values of linked items from Jira Structure

[Dmitriy Ruban]

Hey everyone!

I use Jira Structure (Cloud) and have a formula column helping to calculate estimations and durations following our team rules.

I want to enhance my structure by taking in account linked items. Is it possible to use reference to linked item column value as I could before by mapped variables? 

Additional question: is it possible to set "custom node" in Jira Structure Formula (I want to take linked item and put it into formula custom function and check relevant children).

Thanks in advance!

[Anwesha Pan (TCS) · Accepted solution]

Hi @Dmitriy Ruban 

Unfortunately it is not possible to directly set or define "custom nodes" within a Jira Structure Formula in the same way one might define a new issue type or a specific field.

As you might already know that Jira Structure Formulas primarily operate on existing Jira issues and their attributes (fields, links, hierarchy). While you can use formulas to calculate or display values based on these attributes, or even to create new issues within the structure based on certain criteria, they do not inherently support the creation of arbitrary, non-issue-based "custom nodes" that exist independently of Jira issues.

Thanks,
Anwesha

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Dmitriy Ruban 

You can extract values of linked issues in the Formula column. For example, with a formula like this, you can extract summaries of all issues that are linked with the 'Blocks' link type:

issuelinks.filter($.type = "blocks").map(if $.destination.summary = summary: $.source.summary else: $.destination.summary)

However, the list of attributes that the Formula can access through links is limited at the moment. We have plans to extend it with more fields in the future. 

Please note - in any case. the Formula can access values from issues that are directly linked to issues that are present in the structure. I.e. it is not possible to add an issue, and get values of linked issues of its linked issues (i.e. grandparents/grandchildren through the hierarchy). if this is what you want to do, then you would need to add more hierarchy levels to the structure to ensure that direct references work. 
Alternatively, you can just add the whole hierarchy using generators, and access the data of issues without any constraints.

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

Best regards,
Stepan
Tempo (the Structure app vendor)

[Dmitriy Ruban]

Thanks everyone for your answers!