Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

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

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

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)

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.

Like bernadette.capozzi likes this

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

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)

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
TAGS
Community showcase
Asked in Jira Service Management

JSM June ask me anything (AMA)

Hello Community members! We’re wrapping up the end of JSM June with an Ask Me Anything (AMA) with the Jira Service Management product team. This is your chance to ask all your ITSM questions to o...

255 views 12 14
View question

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