Structure formula column: How do I reference a specific issue by key?

[Yvette Nash]

Hello!

I want to access the attributes of a specific issue referenced by its key. For example, I want the ganttduration of key "ABC-1234." Is this possible? If so how?

Thank you in advance!

Yvette

[Stepan Kholodov _Tempo_]

Hello @Yvette Nash 

If you want to extract some data from a particular issue/work item, and show this data for another issue, it is only possible when:

- the issues are related through the hierarchy somehow. Aggregate functions can be used then (the data can be extracted via referencing the issue in question as a parent/ancestor/child/grandchild of the other issue.
- the issues are directly linked to each other in Jira, then you can use the issuelinks function for extracting the value in one issue for another issue. But please note - right now the list of accessible fields via the mentioned function is limited.

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

Best regards,
Stepan
Tempo (the Structure app vendor)

[Yvette Nash]

So the issue/work item is in the issuelinks array but it sounds like I would not have access to the field I want which is ganttduration. Correct?

[Stepan Kholodov _Tempo_]

Please note - the values that appear in the Gantt Duration column are local attributes of Structure, i.e. these values only exist locally on the Gantt chart of the structure, and in the column of the structure. For an issue to have this value, it should be present in the structure. Alternatively, you can define the Fixed Duration attribute to be taken from a Jira field, but the field will likely not be accessible via the issuelinks function due to the current limitations.

But if both issues are present in the structure and they relate to each other through the hierarchy somehow, then he attribute can be shown via an aggregate function with the field/column reference.

Best regards,
Stepan

[Yvette Nash]

Yep, the issue/work item in question is in fact in the structure and is linked via soft hierarchy. It's the ancestor of all the work items in the structure in fact. I want to house its ganttduration to perform calculations in formula column for each individual descendant work item in the structure. Any help with how this would look in code would be greatly appreciated.

[Stepan Kholodov _Tempo_]

If the item in question is an ancestor, then you can extract its values with a formula like this:
parent#level=-1{ganttduration}

For each issue, depending of its location in the hierarchy in relevance to the ancestor, the level modifier will be different. level=-1 extracts values from the direct parent; level=-2 extracts values from a parent from two levels above, etc.

Best regards,
Stepan

[Yvette Nash]

Hmm, this is not getting me the issue I need. Here is what I logically want to do and cannot get to work because I do not know how to reference the issue I need:

IF issueLinks.FILTER($.type = "soft hierarchy" and $.source.key = "ABC-1234"):

    (ABC-1234).ganttduration/18000000 - JIRA_DAYS(remainingEstimate)

[Stepan Kholodov _Tempo_]

If you're using the issuelinks function, then it will not be possible to extract the linked issue's Gantt Duration value - the function extracts values from the Issue Page, and the Gantt Duration doesn't exist there. You can extract it if it's represented as a field value, or if the linked issue is present in the structure as a parent/child.

Please submit a support ticket at our portal and share screenshots of your setup, we need to have a closer look at it to better understand what you have going on, and what formula can be used.

Best regards,
Stepan

[Yvette Nash]

Yeah unfortunately it is not a hard/direct parent/child link. Hence why we call it "soft hierarchy" and is a link type. Thank you for all the info. I learned a lot in this thread.

[Vronik]

Hi

Look at this post, maybe can help you

https://community.atlassian.com/forums/Jira-questions/JIRA-Structure-formula/qaq-p/3109066

Regards