Grandparent - how can I obtain a custom field from a User Story, 2 levels down

Questions & Answers
1

Our Jira Structure is:
Project Space
–Project Ticket - that contains a custom field Project-Category
----Feature
------User Story

I would like to access the Project-Category field from both the Feature and User Story ticket levels. I’m able to obtain it via Parent from the Feature level, but have not been able to determine how to get a Parent.Parent (aka Grandparent) custom field. I’ve tried getting the grand parent via using GetMemberByKey and passing the parent key from the User Story level, but this is not working

2

Hi @Meade,

Welcome to the eazyBI community!

The solution depends on your actual Jira setup (Plans hierarchy or issue links) and configuration within eazyBI.

If you have built or configured the hierarchy within Issue dimension of your eazyBI account, you might access the grandparent using the .parent.parent references or by using the Ancestor() function - Ancestor.

If you have not built the hierarchy, I suggest doing it as described here - Additional Issue hierarchies.

That might also allow inheriting these fields through the hierarchy to be used for filtering the child and grandchild issues. Please read more about that here - Epic level custom field.

Regards,.
Oskars / support@eazyBI.com