How to remove closed sprints from a structure

[Lars Sundell]

I am trying to set up a structure that shows the issues planned for current and future sprints (including the backlog).

The following automation is set up:

"insert issues from"  is set to add non-epics.
The problem is that the filter "Show Sprint: Active ...." does not seem to have any effect:

The problem is that if a issue has been moved trough sprints the sprint field includes many spint values, typically 1, 2, 5, 6, 10 and so on.
It then ends up in all those sprints. The filter does not seem to have any effect. 

I can get rid of the closed ones by adding another filter like "resolution != unresolved", but the ones still open will be shown in all sprints they have been part of. 

I would expect them to end up in the backlog. How can I achieve that?

[Martin Wasiak · Accepted solution]

Has anyone from Structure acknowledged this as a bug?

[David Niro _Tempo_]

Hello Martin,

David from ALM Works here.  This is currently a limitation in the Filter Generator.

The solution presented by Mario in response to the original question does work though.

You will want to utilize Transformations rather than Generators to add the "Active Sprint" filter to your structure.

To see if this works for you:

• turn automation "off" by clicking on the automation button (you should see the generators, orange text, disappear. they are still working in the background)
• select the transformation and/or the quick transformation icons (highlighted in image)
• click on the add structure transformation option that is now available
• select Filter
• select Hide Closed Sprints

[Christopher McConnell]

Found that even this did not work, so utilized a jql filter: sprint not in closedSprints() - this let me get active, and upcoming sprints as well for planning purposes. 

[Mario O.G]

Hi Lars, 

How are you? 

As Piotr mentioned, for now, the workaround would be to use the (Hide Closed Sprints) generator as a quick transformation.

Quick Transformations: https://wiki.almworks.com/x/YLDrAQ

Currently, The Hide Closed Sprint generator only works when applied to a sub-structure (Insert > Structure) 

We already have an improvement task for this limitation, and we'll be evaluating where this fits into our roadmap.

I'll make sure to post an update on your question if and when it becomes available.

(Thank you for using Structure).

Mario O.G

[ALM Works]

[Jesper Nielsen]

Hej Mario - any further progress on these improvements? I would love to be able to hide closed sprints both when inserting Sprints as a column, and not having them shown when e.g. grouping by sprints

[Martin Wasiak]

Hi Mario and Piotr,

Where are we with improving Structure to overcome this limitation?

[Ryan Belmont]

We'd also like an update on when this will be resolved, or at a minimum when Quick Transformations will be available for Structure Cloud? We have a potentially great report we want to use that is rolling up number of tickets and story points by sprint by developer, but the rollup is functionally useless right now because it's counting the same tickets repeatedly if they're being carried through multiple closed sprints. It feels like this should be a much easier fix?

[David Niro _Tempo_]

Hello Ryan,

David from ALM Works here.

We don't have a timeline to share just yet.  I have made a note of your interest so that we can provide an update when a solution is available.

Best Regards,
David Niro
www.almworks.com

[Rthomas]

Any update here?

[pgierasi]

As a workaround you can add structure transformation Filter (Hide closed sprints). It works for me. 

[Anchel Labena]

I've tried every single suggestion in here, but no matter which way I go through, from using a quick transformation to hide closed sprints to applying a generator when inserting as a sub-structure, but I still keep seeing most of the closed sprints no matter what.

Can anyone help explain why this is a thing? As it has been explained in other posts, if a task has been moved from one sprint to the next, it will keep getting duplicated under every closed sprint it's been a part of, instead of just showing me the currently active sprint and future sprints.

[Alexander Bondarev]

I got the same problem now :(

[sdua]

I am using Structure cloud, Is this issue resolved ? I want to see last 6 Sprints only (Closed or Open). 

I am facing same issue: The problem is that if a issue has been moved trough sprints the sprint field includes many spint values, typically 1, 2, 5, 6, 10 and so on. SO I see old sprints also. 

[Lars Sundell]

I did find a workaround for this that works quite well (We have server, but I guess it would work in cloud as well):

Add an automation filter->JQL Query with the following query: "sprint in openSprints ()"

On my side I still see some closed sprints, but the list is much shorter.