hello, we have a report that is displaying time on our epics. within this report we would link to display the parent link (initiative) name and a custom field (contact) name.
Initiative Name
When i use the built in ‘issue portfolio initiative’ it displays the correct key, but i would like to display the name instead. i’ve tried to use [Issue].CurrentHierarchyMember.get(‘Initiative Name’) or [Issue].CurrentHierarchyMember.get(‘Portfolio Initiative Name’) but am getting no results.
Contact (Custom FIeld)
On the Initiative, we have a custom field “Contact”. How would I display that value on the parent (Initiative) that is linked to the Epic?
The recommended approach for this case is to access the initiative from epic using the GetMemberByKey function. Another function GetCaption is needed to have the full name of the Issue
The following formula gives the name of the initiative at the Epic level:
Another, a bit shorter solution might work, but the result, in this case, is not limited to Epic Initiative level (it will show the parent name for each level):
[Issue].CurrentHierarchyMember.Parent.GetCaption
You can also apply pattern matching to extract only summary part of the parent issue caption:
Hello, I used your example to get a property of a parent, but the property is ‘Status_id’. How can I get the status name of the parent? I can’t find it as a property. Thank you!
Later edit: I actually found this page and managed to display the member name: GetMemberNameByKey