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

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 do I filter DONE task on a specific date interval?

I need to filter  on a kanban board DONE tasks on a specific weekly time interval, for example DONE tasks from July 5th until July 9th

2 answers

2 accepted

4 votes
Answer accepted
Jack Community Leader Jul 15, 2021

Create a quick filter with a JQL like this…

status changed to done during (2021-01-01, 2021-01-15)

Jack Community Leader Jul 15, 2021

If you want a dynamic weekly view then

status changed to done during (Startofweek(),endofweek())

Thank you very much! Unfortunatly is it not working. I receive a green check and at the same time a message of not finding the JQL commend Done (...)

 

erro.PNG

Jack Community Leader Jul 15, 2021

As Trudy points out you cannot use statuscategory in that manner. That is why I used Done in my example.

If indeed you have multiple ’done’ statuses then assuming you set the resolution field, which you certainly should, then consider the following…

Resolved >= 2021-01-01 and resolved < 2021-01-15

Hi Jack, this worked too, but I received less tasks than using the Status field. (same time interval) I have to understand why this happens, since I expected more results with this filter

Jack Community Leader Jul 19, 2021

I can’t say for sure but maybe you should check to see if the resolution is actually set on the issues that are not showing up. The “resolved “solution requires that the resolution field is being set with an issue is moved into a status of type done category.

Got it! makes sense. Thank you

0 votes
Answer accepted

Reference document:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CHANGEDCHANGED

You cannot use the CHANGED operator on the statusCategory field.

Try this

status changed to Done DURING ("2021/07/01","2021/07/07") 

Thanks, Trudy! 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

⏰ Day in the life of a Jira Admin!

Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...

64 views 0 6
Read article

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