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

Gajanan Sasane February 25, 2021

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

2 answers

0 votes
Zoryana Bohutska _SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
March 3, 2021

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. 

imgpsh_fullsize_anim (8).png

Regards

0 votes
Moses Thomas
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 25, 2021

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

Brijesh Pathak June 23, 2022

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

Like # people like this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events