Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,291
Community Members
 
Community Events
165
Community Groups

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

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

2 answers

0 votes

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

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

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 Moses Thomas likes this

Suggest an answer

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

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you