Need help with Structure for Jira Expr advanced expression

Question

I am using Structure for Jira.  I have defined a hierarchy of Jira issues using "contains" issue links (parent "contains" child).  I want to define an Expr expression to get the status of the containing "grandparent" of an issue.  I have a working expression for getting the containing "parent" of an issue:

issueLinks
.FILTER($.type = 'Objective' AND $.source = this)
.MAP($.destination.status)

However, when I try to use this approach to go up two levels instead of one level in the hierarchy, it doesn't work:

issueLinks
.FILTER($.type = 'Objective' AND $.source = this)
.MAP($.destination.issueLinks
.FILTER($.type = 'Objective' AND $.source = this)
.MAP($.destination.status) )

Does anyone know how to do what I am trying to do?  Here is the Expr Advanced Reference.

Valerie Knapp_dpp5c6 · Accepted Answer

Hi @Bruce Bowers , thanks for your question. Please consider to open a ticket directly with the vendor to ask for support - Structure by Tempo - Jira Portfolio Management & PPM | Atlassian Marketplace.

In my experience, they are usually very helpful and responsive.

Stepan Kholodov · Accepted Answer

Hello @Bruce Bowers

It is not possible - the Formula column can only access values of directly linked issues to those issues that are added to the structure. If you want to extract values from grandparents, you can do it by either:

- adding parent issues to the structure and accessing values from grandparents through parents via the issueLinks function;
- add all issues to the structure, visualize the hierarchy and extract values of grandparents using the parent{} aggregate function.

I hope this helps. Please reach out to us directly at our support portal if you need further assistance or help with anything else.

Best regards,
Stepan Kholodov
Tempo