Extracting list of linked issues and casting as Issue

Hey all,

Just to clarify my use case, I’ll try to sketch my end goal:

Column 1 Column 2 Column 3 Column 4
Issue 1 Status of Issue 1
Linked Issue A Status of Linked Issue A
Linked Issue B Status of Linked Issue B
Issue 2 Status of Issue 2
Linked Issue C Status of Linked Issue C
I

I have managed to loop through all linked issues and display them as a list in my reports. I even managed to split those up via the “multiple values”-flag in the advanced settings, so that (at least visually) my report looks fine.

The last thing I am missing is the status of the linked stories, but I don’t know how to access this one. I tried to use the CurrentHierarchyMember to “read” the linked issue, but I don’t get any values back. Also, the linked issues “don’t behave” like the real issues, meaning that I can’t drill into those. My guess is, that these are just treated as plain strings.

So in the end I have two questions:

  1. Is it possible to extract the status of the linked issue?
  2. Is it possible to “cast” the linked issue as a real issue, so that we can use the drill down action?

Thanks in advance!

Below how to get the status of the issue, it should be added as an issue itself.
[Requires] would need to get updated to your Link type

Cache(
([Issue].[Issue].GetMemberByKey(
   [Requires].CurrentMember.key),
[Measures].[Issue status]
)
)
1 Like

Hey,

thanks for the code snippet! Works like a charm for the extracting of the status :slight_smile:

Now only question 2 remains

@DavidS for your 2 questions:
1.- “Is it possible to extract the status of the linked issue?” Answered: Yes, you have the code

2.- " Is it possible to “cast” the linked issue as a real issue, so that we can use the drill down action?"
you can do it like this:

Where you can see I imported the dimension “Requires” into the the Rows and it enable to go into the source data of the issue

This is basically what I want, but I don’t have the right-click option to do so.

Maybe the extracting is not correct? I’ll post the code below

data_type = "string"

var issuelinks = [];

if (issue.fields.issuelinks) {
  var links = issue.fields.issuelinks;
  for (var i = 0; i < links.length; i++) {
    var link = links[i];
    if (link.inwardIssue) {
      if (link.type.inward == "required" && link.type.name == "Benötigt") {
        var combined = link.inwardIssue.key;
        issuelinks.push(combined);
      }
    }
  }
  issue.fields.customfield_link = issuelinks.join(";");
}

return issue.fields.customfield_link ;

You are importing as “string”, in this case it should be as “dimension”. Like:
data_type = “string”
dimension = true

However, what we have in our options is something straightforward. Because we have the links already there to be imported.

I have the checkboxes checked, so it is imported as a dimension.

Would you be able to provide your code snippet for extracting the link? Do you extract your Required-Link the same way as I do?