Hello,
I am attempting to nest issue types: products and milestones, into my existing issue hierarchy from Jira. The existing issue hierarchy is: Initiative → Capability → Feature → Epic → Parent → Sub-Task. On the Jira side, Products and Milestones are brought into the structure via Child-Parent issue links (outward=is a child of, inward = is parent of). My current progress has led me to this code below, but I do not believe it is working. I would like to see the products/milestones (products right now for simplicity) underneath the respective hierarchy level as “siblings” to the level below. i.e. if a product is a child of an initiative, it will be listed on the same level with the capabilities that are below the same initiative.
[[jira.issue_hierarchies]]
name = "Gantt"
all_member_name = "All Gantt Items"
levels = [
{name="Initiative",key_column="jpoh_parent_5",issue_type="Initiative"},
{name="Capability",key_column="jpoh_parent_4",issue_type="Capability"},
{name="Product",
calculated_member_expression =
"NonEmpty(
Generate(
[Issue].CurrentMember.Parent.LinkedIssuesByLinkType('is parent of'),
[Issue].CurrentMember.Parent.LinkedIssuesByLinkType('is parent of').[Issue].Key,
', '
),
[Measures].[Issues created]
)",
issue_type="Product"},
{name="Feature",key_column="jpoh_parent_3",issue_type="Feature"},
{name="Epic",key_column="epic_key"},
{name="Parent",key_column="epic_parent_key"},
{name="Sub-task",key_column="subtask_key"}
]
Thank you.