Extracting list of linked issues and casting as Issue

Questions & Answers
, ,
1

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!

2

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
3

Hey,

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

Now only question 2 remains

4

@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:

image
image1730×572 68.6 KB

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

5

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 ;
6

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.

image
image553×879 44.5 KB

7

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?

8

Hi, @DavidS

Welcom to the eazyBI community.

Thank you, @Nacho, for the help; it is much appreciated.

@DavidS, if you still have questions regarding this, please send:

  1. the report definition (how to export that, please find here: Export and import report definitions).
  2. settings for the Issue links, print-screen to see the settings and the code

Please send all above to the support@eazybi.com.

Thank you,
Ilze