How to get summary and status of linked issue

Questions & Answers
1

Hi,
assuming I have an issue called REQ and for each REQ I have several tests(TEST) that are linked to it.
my goal is to create a table as follow:
| REQ issue | all linked TEST | TEST statuses | TEST summary |

1.I managed to create a [jira.customfield_reqs_tests] in advanced settings and to import as dimension and property.

2.I created a new calculated measure with the following code in order to get all the statuses:
CASE WHEN
[Issue].CurrentHierarchyMember.level.Name = “Issue”
AND
Not IsEmpty([Issue].CurrentHierarchyMember.get(‘reqs to tests linked’))
THEN
Generate(
[Issue].[Issue].Getmembersbykeys(
[Issue].CurrentHierarchyMember.get(‘reqs to tests linked’)
),
Cast ([Issue].CurrentMember.Get(‘Status ID’) as string), ', ’
)
END

but I got the id of the status,for example - 10121, 10819
my questions:
1.how can I get the name of the linked issue status?
2.how can I get the summary of the linked issue?

thanks

2

Hi,

There are just minor steps remaining for completion of your use case:

  1. The issues hold status ID as the property; you need to apply one more GetMemberNamebyKey function:
[Status].[Status].getMemberNameByKey(
  [Issue].CurrentHierarchyMember.get('Status ID')
)

You can check the formula in the standard Issue status property in the data cube:

image
image1650×770 59.1 KB

  1. The summary must be extracted from the name of the linked issue using string processing. One way to do that would be the following:
ExtractString(
[Issue].CurrentHierarchyMember.Name,
".+-\d+ (.*)",
1)

Kindly,
Janis, eazyBI support