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?
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:
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).
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?
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.
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.
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.