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
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')
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
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'),
","
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
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.