How would I find a ticket Created in the previous month and closed in a different month by JQL?

Question

I want to find all the issues created in the previous month and closed in a different month by JQL.

Brijesh Pathak_luggto · Answer

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

Zoryana Bohutska _SaaSJet_ · Answer

Hi @Gajanan Sasane

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

Moses Thomas_08kyb0 · Answer

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