GetCaption from linked Issues

Questions & Answers
1

I created a dimension from linked issues

[jira.customfield_linked_issues]
name = “Gelinkte Issues”
outward_link = [“causes”,“relates to”,“Is parent for”,“created”,“blocks”,“clones”,“In Release”,“Beheersmaatregelen”,“Draagt bij aan topstrategische risico’s”]
inward_link = [“created by”,“is caused by”,“relates to”,“Is child of”,“is blocked by”,“In Release”,“Verbonden aan risico”,“Bijdragende risico’s”]
multiple_values = true
dimension = true

Now I want to show the caption of the linked issues. I know you can use "Get Caption, but this doesn’t seem to work for Linked issues.

I have made next to show me the linked issues, with Issuetype and status. But I would also like to have the name from the linked issue:

Case
When
[Gelinkte Issues].Currentmember is [Gelinkte Issues].Defaultmember
Then
Generate(
– get a list of linked issues
[Gelinkte Issues].[Gelinkte Issues].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get(‘Gelinkte Issues’)
),
– show by key
“[”||
cast([Gelinkte Issues].CurrentHierarchyMember.Key as string)
||“](找不到项目”||cast([Gelinkte Issues].CurrentHierarchyMember.Key as string)||") "
–Met issuetype
|| " - " ||
– show issue type
[Issue Type].[Issue Type].GetMembernameByKey(
[Gelinkte Issues].CurrentHierarchyMember.Get(‘Issue type ID’))

|| " - " ||

– show issue status
[Status].[Status].GetMembernameByKey(
[Gelinkte Issues].CurrentHierarchyMember.Get(“Status ID”)),

|| " - " ||
[Issue].[Issue].GetMembernameByKey(
[Gelinkte Issues].CurrentHierarchyMember.Get(‘DISPLAY KEY’)
.GetCaption)
)

chr(10)

2

Hi @_P3

Thanks for posting your question!

The problem with the last statement is that you are looking for GetMemberNameByKey while you should be using GetMemberByKey and then use Get.Caption

Please try the below code and see if it works for you as expected

Case
When
[Gelinkte Issues].Currentmember is [Gelinkte Issues].Defaultmember
Then
Generate(
-- get a list of linked issues
[Gelinkte Issues].[Gelinkte Issues].GetMembersByKeys(
[Issue].CurrentHierarchyMember.get('Gelinkte Issues')
),
-- show by key
"["||
cast([Gelinkte Issues].CurrentHierarchyMember.Key as string)
||"](找不到项目"||cast([Gelinkte Issues].CurrentHierarchyMember.Key as string)||") "
--Met issuetype
|| " - " ||
--show issue type
[Issue Type].[Issue Type].GetMembernameByKey(
[Gelinkte Issues].CurrentHierarchyMember.Get('Issue type ID'))

|| " - " ||

-- show issue status
[Status].[Status].GetMembernameByKey(
[Gelinkte Issues].CurrentHierarchyMember.Get('Status ID'))
|| " - " ||
[Issue].[Issue].GetMemberByKey(
[Gelinkte Issues].CurrentHierarchyMember.Get('DISPLAY_KEY')
).GetCaption, chr(10)
)

END

Best wishes,

Elita from support@eazybi.com

3

Found also a simple solution:
I changed the .Key in the cast to .GetCaption as string

“[”||
cast([Gelinkte Issues].CurrentHierarchyMember.GetCaption as string)
||“](xxxxxxxxx/browse/”||cast([Gelinkte Issues].CurrentHierarchyMember.Key as string)||") "