It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to create a Kanban Sub-filter to hide Finished issues older than 1 month Edited

Harry Feb 13, 2018

I want to have a sub-filter on my Kanban that hides all issues that are older than one month and:

  • Done
  • Resolved
  • Closed
  • Fixed

 I still want to see issues that are older than a month and do not have any of these status's or resolutions.

 

I have tried using created >= -4w AND status!=Resolved but this also seems to hide some other issues like 'selected for development' ones that are older than a month

 

 

2 answers

1 accepted

1 vote
Answer accepted
Maarten Cautreels Community Leader Feb 13, 2018 • edited

Hi Harry,

This is possible using either the resolved date (fastest option) or using a history search (usually less performant but has more options).

You could add the following snippet to your Kanban sub-filter based on the resolved date:

resolved >= -4w OR resolved IS EMPTY

Or you can have a look at my JIRA Search Ninja series, specifically to the post about History Searches.

Hope this helps.

Best,

Maarten

Harry Feb 13, 2018

This doesn't show and Done / complete/ resolved issues at all though.

I still want to be able to see Done / resolved / complete that are younger than one month old.

I think this might be what I need:

created >= -4w AND (status != "Done" or status != Resolved or status != Closed or status != Complete)

Harry Feb 13, 2018 • edited

Apologies I realise now that I did not specify that originally.

Essentially all I want is a way to let old finished tickets automatically 'drop off' the end of the Done column in the Kanban board. Otherwise we will have hundreds of issues clogging it up.

Maarten Cautreels Community Leader Feb 13, 2018

Hi Harry,

No problem, I think I might have missed a few things from your original question as well. With young you mean created in the last 4 weeks? 

My filter would show you all issues except for those that have been resolved at least 4 weeks ago. Including issues that would have been created months ago. 

That way you keep track of all the work that has been done in the past 4 weeks whenever it was created.

If that's not what you're looking for, please let me know!

Best,

Maarten

Harry Feb 13, 2018

ahh yes I think you are right actually that your query is what I'm looking for.

Its just when I was testing it I could not see any done tickets so assumed it would not show any of those.

Thanks!

Hi Guys...

I am looking to obtain the same for my filter. Currently, I have a very simplified filter, but overtime, I know our "closed" issues or you are referring to the done will have hundreds on the board). I want the ones after the last day of the month to be removed off the board.  Hope this makes sense!  How would I add that syntax to my current filter:

project in (CBL, CBLSCRUM) ORDER BY Rank ASC

 

created >= -4w AND (status != "Done" or status != Resolved or status != Closed or status != Complete)

1 vote
Domagoj Zecevic Feb 13, 2018

Writting this out of my head

 created >= -4w AND (status = "Done" or status = "Reolved or ...)

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

736 views 7 0
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you