Sub Task for issue links

Questions & Answers
1

I have a table where I display massive incidents and issue links (Issue type: IT Problem).
I need to also display Sub-Tasks for (issue links (Issue type: IT Problem)) in the same table.

Massive Incident -
| - Issue Links(Issue type: IT Problem) -
| - Sub-Task

[jira.customfield_issue_links]
name = "Issue Links"
outward_link = ["relates to"]
inward_link = ["relates to"]
issue_type = "IT Problem"
dimension = true
multiple_values = true
group = "Linked issue dimensions"

-- annotations.group = 4 Issue links and hierarchies
Generate(
-- get a list of bug issues
[Issue].[Issue].GetMembersByKeys(
  [Issue].CurrentHierarchyMember.get('Issue Links')
),
-- show by key
cast([Issue].CurrentHierarchyMember.Key as string) 
|| " - " ||
-- show bug status
[Status].[Status].GetMembernameByKey(
  [Issue].CurrentHierarchyMember.Get("Status ID")),
chr(10))
2

This is my code, it produces empty cells, where is my mistake?
Thanks!

Generate(
  [Issue].[Issue].GetMembersByKeys(
    [Issue].CurrentHierarchyMember.get('Issue Links')
  ),
  Generate(
    Filter(
      Descendants([Issue].CurrentMember, [Issue].[Issue]),
      [Issue].CurrentMember.Get('Issue type') = "IT Problem sub-task"
    ),
    [Issue].CurrentMember.Key || " - " || [Issue].CurrentMember.Get('Status'),
    ', ' 
  ),
  chr(10)
)
3

I did this, maybe someone will need it:

Generate(
  [Issue].[Issue].GetMembersByKeys(
    [Issue].CurrentHierarchyMember.get('Issue Links')
  ),
  -- show sub-tasks for each Issue Links
  Generate(
    [Issue.Sub-task].[Parent].getMemberByKey(
      [Issue].CurrentHierarchyMember.Key).Children,
    [Issue.Sub-task].CurrentMember.getString('KEY'), ','),
  chr(10))
1 Like