Create JQL query for issues resolved in Particular month

[Deleted user]

I would like to create filter for Issues

1. Resolved in particular month

2. For each Issue types

We are using Tempo for timesheets and resource planning, I would needs this filter for me to track total hours spent on each issue type on a particular month. 

Also is there any way of doing it without having to create filters every month? 

[Ash Pitt · Accepted solution]

Hey @[deleted] 

If you're after a solution that does not mean you have to update a filter each month you can simply use the below JQL which will show you everything that's been resolved in the previous month.

resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-1)

you could then add to your JQL

and type = IssueType

So you could have a filter set up for each issue type you wanted to report on - eg

resolved >= startOfMonth(-1) AND resolved <= endOfMonth(-1) AND type = Task

would return all tasks that were resolved in December 2020. As soon as Feb 1 comes along, that would report all tasks resolved in January 2021.

Make sense?

Ash

[Suma Pralhad Kustagi]

Hi,

  Incase we need to see issue resolved for last two months ,what would be the modification..

Regards,
Suma