I want to find all the issues created in the previous month and closed in a different month by JQL.
Optionally, when you don't know how to build JQL, you can try to use Dynamic Filters: JQL Replacer for Jira. Choose the date ranges you need (as shown on the screen below), and you'll get the list of issues you are searching for.
Regards
Hello Sisane,
As i understand you want a query to show issues that will be resolved in the future
created > startOfMonth(-1) AND resolutiondate >= startOfMonth(0)
created > startOfMonth(-1) gives ticket created in the last month
resolutiondate >= startOfMonth(0) give ticket where resolve starting in the current and above
I hope it helps.
Kind regards,
Moses
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Moses, it helped me with my query.
with your query it was giving me all tickets starting previous month till date (includes current month as well)
Below query help me getting data only for previous month
"created > startOfMonth(-1) AND created < endOfMonth(-1)"
Thanks
Brijesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.