Get related issues, filter and display related details in JIRA Structure

[pritchsc]

Hello, 

I'm trying to solve the following problem with JIRA structure, using columns and formulas. Any help/pointers would be much appreciated. 

Problem: I would like to display linked issues and that related data for a given issue type in a jira structure board. Prod testing teams create product defects in a JIRA project. Engineering team clone issues and prioritise in sprints. We want a single aggregated view that provides column of cloned issues and status, e.g. I would like to present in the following format: 

Project ID | Summary | Status | Owner | Linked Issue Status | Linked Issues Sprint End-date

For the last two columns, my approach was to create a column with a formula that would get find the issueLinked where type is "Clones" but only match where the project name is ENG. Then foreach, get the property status (Done, etc...). If in progress, I would like to check if this is in a sprint, and for that sprint, get the target completion date. 

I can do this by extending the issues and adding a column, but wanted to have a single-level view of the data, rather than have teams drill-down. 

I have found the following code example

if(match(issueLinks .FILTER($.type = 'Cloners' AND $.destination = this);"*ENG*"), "EXPAND WITH CODE TO CHECK IF NOT COMPLETED AND RETURN SPRINT DATE OR DUE DATE ON ISSUE)

Thanks all. 

[David Niro · Accepted solution]

Hello @pritchsc ,

Unfortunately, this is not possible to do without adding the other issues to the structure, as you have identified.

Using formulas, we can access the attributes of the issues in the structure.  Issues linked to the issue in the structure can therefore be identified through issuelinks. 

The values you are trying to access are attributes of the issues that are linked to the issues in the structure.  In other words, two steps removed.  

We do have a task related to this extension of the expr functionality and I have added your vote.

I will follow up with you here if there are any updates to share.

Best,
David

[pritchsc]

Thank you for the clarification David - much appreciated!

[larry joseph]

@pritchsc I was looking to do something similar and got the formula below to work. Seems to match your requirements, though this probably only works if there is only one Cloned issue. This finds the links matching <your link type> that are In Progress and in <your project> Then returns that issues duedate.

issuelinks .FILTER($.type = "Your Link Type" AND $.source = this and $.destination.project = "your project name" and $.destination.status = "In Progress") .MAP($.destination.duedate)