Iterate through Linked Issues

Hi Team,
Have a requirement to get details of an Issue in below format
Epic - > Story - > Testcase → Defect

To achieve above used the below Custom code to get all the linked issues

[jira.customfield_linked_issues]
name = “Links of issue”
outward_link = [“relates to”,“blocks”,“is test case of”]
inward_link = [“has test case”]
dimension = true
multiple_values = true

Able to pull the linked issues separated by comma in a Table, Count of Linked issues.
Need to Iterate through Linked issues to get details of each Issue.
Request you to let me know what functions or methods we can use in eazyBI to achieve these

Thanks in Advance.

Regards,
Farnaz

Hi, Franaz

The dimension members created from issue link contains all the same properties as issue dimension.
So, the formula like this should be used for accessing the linked issue properties:

[Links of issue].[Links of issue].Currentmember.get('Project key')

There is a public eazyBI account providing several examples of how to access the attributes of linked issues. Stories with Bugs details - Issues - eazyBI Demo Training - eazyBI

Kindly,
Janis, eazyBI support

Hi Janis,
yes using the expression you mentioned above gets me the properties of a linked issue.

Using below able to get the details of first child
[Issue].CurrentHierarchy.GetLinkedmembers(‘Links of issue’).Item(0).Get(‘DISPLAY_KEY’)

In above expression we need to change the Index in ITEM(N) to get subsequent linked issues. Depending upon the count of linked issues need to get details

example : Linked Issue count = 10
[Issue].CurrentHierarchy.GetLinkedmembers(‘Links of issue’).Item(0)
[Issue].CurrentHierarchy.GetLinkedmembers(‘Links of issue’).Item(1)


[Issue].CurrentHierarchy.GetLinkedmembers(‘Links of issue’).Item(9)

Able to get count of linked issues using the method “Count”. Need to get the child objects without hard coding the index

Hope you are able to get my query.

Regards,
Farnaz

Hi Farnaz,

The MDX language has limited options to loop over several members in the set.
The Generate function can be used to have the full list of the linked issue details.

The following formula generates the comma list of the linked issue assignees:

Generate(
  [Issue].CurrentHierarchyMember.GetLinkedMembers('Links of issue'),
  [Issue].CurrentMember.GetString('Assignee name'),
  ","

Kindly,
Janis, eayzBI support

Hi Janis,
Thanks, using the Generate function was able to get the list separated by comma.
Further using a Case method was able to get execution status too as below

Testcases
“TC1 = PASS
TC2= FAIL”
“TC3 = PASS
TC4= FAIL
TC5 = PASS
TC6= FAIL”
EazyBIReport

Request you to let me know if we can use Filter + Case methods to get count of Testcases Passed/Failed. Tried using the Generate + Case method but it returns NULL for the testcases which doesn’t meet the criteria.

Regards,
Farnaz