Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to hide the closed sprints from the open sprints, future sprints and backlogs filter

Hi ,

I am creating a filter to display only the issues in open sprints, future sprints and backlogs but when i apply the filter it is also displaying the closed sprints as well.

Is there is a way to hide the closed sprints from the filter results and only display the open, future sprints and backlogs .

This is the below filter i am using :

project = "DPM " AND (Sprint is EMPTY OR Sprint in (openSprints(),futureSprints()) or Sprint not in closedSprints())

Please Let me know if I am missing anything in the filter .

Thanks in Advance!!




1 answer

0 votes

Your query actually contradicts itself, and has little to do with your actual question.

What you want to see is actually a lot easier, you've overcomplicated it by thinking in sprints.

You say "open sprints, future sprints and backlogs", but you could actually just write that as "all open issues".  There's no need to reference the sprints unless you actually want to see issues that you've already moved to done and put them in a sprint (which is pretty pointless, as the issues are done)

If you must do it via sprints, then the simple version is to go for a negative, exclude what you don't want:

(Sprint not in closedSprints() or Sprint is Empty)

Hi Nic,

Thank you for the response on this .

Sorry If I could not convey the actual requirement to you.

The main issue is that the issues which are currently under the Active sprint( For ex. sprint 51) were earlier part of the closed sprints (Sprint 49 & sprint 50).

So at the time of closing the sprints 49 & 50 the client moved the issues to the Active sprint i.e. Sprint 51.

So whenever I am applying the filter- basically it should only display the Active sprint i.e. Sprint 51 but the results are displaying the closed sprints as well i.e. Sprint 49 & sprint 50 along with the Active sprints.

I just want to know if its possible to hide the closed sprints from the filter results.

Let me know if you have any questions on this .




Ah, it's not the filter then.

" it should only display the Active sprint i.e. Sprint 51 but the results are displaying the closed sprints "

This would be lying to the users though.  An issue that is drawn into sprint 49, then rolls over into 50, and then 51, is in all three sprints.  It's useful to know that, and a report that fails to show the sprints for an issue would be inaccurate.

However, wouldn't the usefulness depend highly on the report's purpose? I have the same issue, where the report is meant to be current and have a forward focus, not what we were focusing on previously. Even if some of the epics we are currently working on existed in previous sprints. I'm not saying that they did not exist in previous sprints, but I am saying that for its purpose, it doesn't matter and is just clutter that I have to sort through. I can create another view for the over-arching work breakdown if I need that level of detail.

Since the information in previous sprints will never change, nor ever have more work done on or added to them in that sprint, it is not a needed item in this specific report. I like having the ability to keep the related work from previous sprints, but that would only be for those use-cases where I want the background and pattern of work.

So the past sprints are not Active, the epics are. If I am trying to group and filter on the Sprint level, why would that make a difference if it has epics that were also active in previous sprints? If I wanted to see the span of work on an epic, I would group first by Epics and then see all of the sprints it was apart of.

I would also argue that it is not lying to the user.

  • For example, this is my current need: If I am working on Epic A and it has dragged on a few sprints or months and someone asks: "What work do we have left to complete?". Am I lying to them by not telling them what has been completed  since Epic A was started, or am I being more accurate by only providing the information they want/need in that moment?
  • Or not related to project management: even just a quarterly/annual graph of total revenue by industry or region that does not show the prior year or what customers existed last year compared to this year. It's not that the company didn't exist or was providing an entirely different product, just that it is not a part of the report's scope.

I am all for wanting to ensure accuracy and effectiveness in a report, but there are certain times you want the big picture, and certain times that you want a smaller picture, but leaving off a perspective is not necessarily deceptive.

Let me know if I am missing a variable or something here, because this does seem quite useful for my current needs, and I have just been ignoring the previous sprints. But, either way, it sounds like this was intentional and/or is not seen as a defect. So I guess I found my answer that it cannot be done in structures at this time.

Yes, but I think you've missed the point of the question.  The report they're looking for is not what you appear to be describing

I was just giving examples, of other instances where report accuracy is highly dependent on its goal and scope. If I am correct that this is the same/ a similar issue to mine, I did not feel like saying it is inaccurate or deceptive was a good reason that past sprints are still showing even after specifying not in closedSprints().

I specifically want to have a structure of my team's work in the active sprint, future sprints, or the backlog so I can have a report of work to be done and when/if it is slated to be worked on. I get the exact same issue where I still see past sprints because some of my epics were worked on in that sprint and the work wasn't completed and got moved to the next sprint. So I think myself and Pankaj are seeing the same issue. 

I want to see only the current and future items for planning and quick reference, but for what I use this particular report for, I have no need for the past sprints, even if they have work that is still ongoing in this sprint is also a part of that sprint. As long as it wasn't work that just never got completed and moved to the next sprint, it is just clutter that I have to repeatedly over-look.

Ah, hang on, there's an issue here - you don't really work on Epics during sprints. 

Epics are containers for stories, they are not sprint items.  What sprint you worked on the issues they contain is not important.

Also, you seem to be thinking of sprints as containers of specific pieces of work.  They are not, they are time-boxes.  If you want to look at work in progress and work to-do, look at your open issues.  The sprints are not for planning at a higher level, they are for a team to time-box their work.

Oh okay, I see what happened. I was meaning user stories not epics.

I understand that Epics are not measurements of times or are actually worked on themselves during a sprint. As well as a sprint is nothing more than a pre-defined time-box (generally 2 weeks) for both a team and the project manager to break down work into a certain granularity, but also provide time-frame estimates for which the business uses to plan. I use the term sprint not as a container, but as descriptor, like saying "last month's rent". The rent is not contained by the month, but is typically aligned with it. So a sprint does not contain user stories, but that is describing that instance of work that took place during that sprint.

But when you said: "Epics are containers for stories, they are not sprint items.  What sprint you worked on the issues they contain is not important.", you are right; I was meaning user stories, but I have everything also grouped by epic, and I was getting confused. So when I mentioned epic in my comment, it should be user story instead.

I want to look at the user stories planned for the current sprint, future sprints, and unassigned user stories. I do not want to see any previous sprints or the stories worked on. However, when I try to filter out previous sprints, any sprint that has user stories that were time-boxed during that time and moved over to new sprints, still appear.

So for instance, I have a user story that is broken down to the right size, but due to inter-team dependencies, has been moved through a few different sprints while waiting to be started. When this happens, it creates a grouping for each of the previous sprints it was in, its epic, and another line-item for its user story itself. So the report is displaying duplicate records for each of the associated sprints. Which causes a lot of clutter if you have a couple of these user stories out there that are waiting to be picked up, but are still needing to be in each current sprint for team visibility.

Seeing the leftover items can be helpful, but for the purposes of this report, I don't want to see the previous sprints. I am just wanting "sprint not in closedSprints()" to not display user stories from past sprints.

I know this is largely handled by the team backlog that is provided by default, but I like to be able to add different field values in the columns and have calculations if need be. So I would love to be able to use structures.

So I think you're still missing something here.

You say "I want to look at the user stories planned for the current sprint, future sprints, and unassigned user stories."

That tells me you are trying to do future work planning.

But then "I do not want to see any previous sprints or the stories worked on." and then talk about not wanting to see "moved to new sprints"

That makes a nonsense of your planning, because you are now choosing to ignore issues that still need working on.

This is why I'm saying the sprints are not what you should be looking at.  If you insist on looking at them, that can work, but you have to stop saying you don't want to see issues that have been in closed sprints.  You can't plan by ignoring work that still needs doing.

This is my report for just generally looking at work ahead and for quick reference. I simply want to know if I can do this, and if so, how?

It will take a long time and a lot of back and fourth to describe my entire team configuration, methodologies, reporting structure, training, etc.... I am not using this report to give my director a completion date or any information. This is for me to look at as I am going through most of my weekly meetings as a quick glance that I can either look at it from the epic level of general work, or quickly expand to see the specific deliverables of that epic.

We handle all of the detailed nuances of planning in specific meetings, where I use different charts and reports. However, in every other meeting I have, I don't need to know that user story xxxxx was started in sprint x and was moved over in (a, b, and c sprints). I know that is an on-going user story that has been going for multiple sprints. If I need that level of detail I can go in and click on it.

So I would not like to see past sprints, because as I said before, different reports (with different uses, outcomes, and defined scopes) require a different set of displayed information. This is not a master report that I use for every decision I make, just a reference sheet that I find helpful and it could be a lot more helpful if I could make the specification to see or not see duplicate user stories from previous sprints. Not that I want to remove the functionality all together. Just to remove it from this report.

So the problem here is still "So I would not like to see past sprints"


  • misses the point of doing sprints - they are for your teams to do their planning, not higher-level bits of your organisation
  • past sprints inform capacity, not planning
  • it does not work, because you are choosing to ignore work that still needs doing.

I think you need to take a step back and look at what you are actually trying to plan and report on.

There's still a lot to unpack here, but the starting point is "why do you think sprints are a way to plan (outside the single team)?"

Why are you not trying plan based on the issues you actually have, instead of team time-boxes within which your team work? 

I have said this previously, so I am not sure if you are not reading those parts or simply don't care. I am trying to explain myself, but I have to keep repeating that this is not some master report for the organization. This is meant for the team level. Just one team. Just one view of that team, which does not mean the only view. You aren't actually helping me, your just telling me I am so far wrong you literally cannot see an even slight reason for my question; and therefore, it isn't worth answering. I just want it for this report view for me personally.... this is just one of the things I would like to look at. We have very few issues that span over sprints, but there are a few that always drag on, and it is a known problem, which are tracked separately. People only have so much time for certain priorities.... I fail to see why you think I am not paying attention to it and other things, just because I am telling you just enough information as I need to, for you to be able to help me fix this issue, for this forum post. 

What, then would be the purpose for any other query besides selecting all data from everything? Are you just ignoring that policies, procedures, open defects, other team's work, regulatory requirements, every comment made by a stakeholder for each of the tickets doesn't exist? No, you are just specifically looking for a particular set of data to solve a particular goal. Which may or may not include the entirety of data.

What is the difference between not showing an collapsing the past sprints (Collapsing is a default capability)? Other than of course the clutter I want to get rid of.... Why then, do queries exist? Besides just appending other data on to get a more full picture? Is there, in your professional opinion ever a time to scope a report to a specific topic or question? 

I have other ways of tracking sprints (past and future), and getting all of it in one place is very easy, but separating it out is not as easy. I just want this structure for when I need to quickly look at something we are currently working on, or what we are working on next.... That is 90% of the questions I get asked by people, as we have regular updates. 

I would very much appreciate if you could just give me the benefit of the doubt, because I am not going to explain what experiences and trainings I have had or my company's structure and methods. Both for my personal privacy, but also as good business security practices. I get that it may not be the most efficient to separate out the views, but I feel as though it helps me. I am not user why, as long as I am tracking past sprints elsewhere, that is matters if I want a separate view. In fact, it shouldn't matter if I want a view that doesn't have sprints, or epics and is just line items of work. Everyone has different ways that work for them.

I will just assume that you do not know how and/or won't help. - I am all for getting to the root cause of an issue to solve the actual need, but I have wasted so much more time discussing project management 101, then simply ignoring all of the extra rows and data...

I'm sorry you feel this way, but I am really trying to help.

A big problem for me is that you're writing essays covering huge swathes of stuff we could be talking about and I'm trying to get down to a short answer that will actually help, rather than just take us off down another path that probably won't help.

Can we go back to the basic question (and yes, I know most of it is in previous posts, as will be a lot of what I'll try to say or explain).

What information are you trying to see, at a high level and what are you trying to do with it?  What is it supposed to be telling you, and helping you do?

Not sprints, not issue details, not dates, not the raw data, but the "story".  Something like "I want to be able to plan the outstanding work, and I want to see it in shape XYZ"

Reading this thread has been maddening. I have the same issue as @Jordan Bauman , and the entire thread is a community leader ignoring the main question completely to give their take on how agile "should" work. 

So dismissing the fact that they have been condescending and unhelpful for the life of this thread. 

Is there a way to hide previous sprints in structure. If yes, how? If No, cool thanks. But you don't need the why to provide information to people asking questions on a forum, its completely irrelevant to the question. 

We don't need to hear about scrum/agile theory, its a question about how to use a feature on Jira. 

Its taken 6 months to not have the original question poised by @Pankaj Mahajan 

Like Jordan Bauman likes this

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events