Structure: filter in group by using group name

Flummiboy

Hi,

I have a structure composed of initiatives, epics and their child issues. They are generated dynamically by the "Extend with Advanced Roadmaps(Portfolio) child issues" and "Add issues belonging to epics" generators.
I now want to group the initiatives by label AND in each group I only want to see the child-issues with the same label as the group they are in. Like:

- Group(LabelA)
--- Initiative A
----- Epic A
------- Issue A
------- Issue B

- Group(LabelB)
--- Initiative A
----- Epic A
------- Issue A
------- Issue C
------- Issue D
--- Initiative B
----- Epic B
------- Issue E
------- Issue F
------- Issue G

My generators:

 

Add issues belonging to epics

Extend with Advanced Roadmaps(Portfolio) child issues

Group by Label

Insert issues: (project=MYPROJECT) AND issuetype=Initiative

I can not get it to work. I could add a Formula-column with "PARENT#level=2{summary}==label" and I will get a column which has 1 for issues I want to include and 0 for the ones I don't ... but if I try to add this Formula as a Filter(on level=3) it does not work.
When I add this as a group-by generator it also works, but i will have to apply the grouping on level 4 (group settings pop-up). This will result in two groups "0" & "1" being displayed on the level between the epic and the Child-issues, which is not what I want.

The "PARENT#level" seems to work differently for group and filter generators and the result will also be different depending on the level the filter is applied to, even if the PARENT#level is not relative but absolute.

This also works with just Epics and their children.

 

Flummiboy

I want to share the solution the Jira structure plugin support suggested. First of all, the reason that it is not possible to filter with group names is the order of execution of the generators:

1. Insert
2. Extend
3. Filter
4. Group
5. Sort

So when I tried to filter the groups or use the the group name to filter items in the group this could not work as the group do not exist when filtering.

One solution would be to build structures and insert them into one main structure. The other solution which I applied was to use a Formula Transformation.

The formula proposed by the ALM works support was:

if Level=1: summary
ELSE
labels.FILTER($.MATCH(PARENT#level=-3{summary} OR PARENT#level=-2{summary} OR PARENT#level=-1{summary}))

And it works like a charm!

Maybe this helps someone.