Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Structure: filter in group by using group name

Flummiboy
Contributor
March 9, 2023 edited

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.

 

1 answer

1 accepted

3 votes
Answer accepted
Flummiboy
Contributor
March 22, 2023

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.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, atlassian government cloud, fedramp, webinar, register for webinar, atlassian cloud webinar, fedramp moderate offering, work faster with cloud

Unlocking the future with Atlassian Government Cloud ☁️

Atlassian Government Cloud has achieved FedRAMP Authorization at the Moderate level! Join our webinar to learn how you can accelerate mission success and move work forward faster in cloud, all while ensuring your critical data is secure.

Register Now
AUG Leaders

Atlassian Community Events