Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I create a filter for tickets solved in the current week?

Ian Walker October 3, 2018

Our development workflow works by tickets having a status of IN DEVELOPMENT and then, when they are solved, we move them into another bucket on our JIRA board and the status changes to DONE.

How can I create a weekly filter that tells me the JIRA tickets that were solved (i.e. moved from IN DEVELOPMENT to DONE for the current week - regardless of the ticket creation date)? 

When I create a filter I cannot find any way to set something like RESOLUTION DATE = THIS WEEK.

So my filter looks like this:

<BOARD NAME> / <TICKET TYPE> / <STATUS> / <ASSIGNEE> / RESOLUTION STATUS / UPDATED DATE

So it can look like this:

OurJIRABoard / Bug #1 / Done / DevName / Done / Within last week

But the results don't seem correct. 

For example, in the latest report, it lists a bug that was created on 5th September, updated on 5th September and resolved on 5th September.

Can anyone help me set up this filter correctly? - Thanks!

1 answer

1 accepted

4 votes
Answer accepted
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 3, 2018

Hello,

I think your JQL query should be like this:

resolutiondate > startOfWeek()
Ian Walker October 4, 2018

Hi @Alexey Matveev.

Thanks so much, that has fixed it.  Much appreciated.

Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 4, 2018

You are welcome!

Suggest an answer

Log in or Sign up to answer