JQL to find all the issues which are created in previous months and resolved in current month

[Gajanan Sasane]

I need JQL to find out all the issues which are created in previous months and resolved in current month.(without using any plugin)

Thanks

[Alexis Robert · Accepted solution]

Hi @Gajanan Sasane , 

you can use the following JQL : 

(created >= startOfMonth(-1) and created <= endOfMonth(-1) )  AND resolutiondate is not EMPTY  AND ( resolutiondate >= startOfMonth() and resolutiondate <= endOfMonth())

Let me know if this helps, 

--Alexis

[Gajanan Sasane]

Hi @Alexis Robert :

Thanks for your answer.

Is there any option to show all past months issues?

[Alexis Robert]

Hi @Gajanan Sasane , 

you can modify the function arguments to go back even further : startOfMonth(-1) will give you the previous month, startOfMonth(-2) 2 months ago, etc.

[Gajanan Sasane]

@Alexis Robert:

Thank you so much.