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,297,241
Community Members
 
Community Events
165
Community Groups

Jira JQL Query for Issues resolved today / Jira Query for issues resolved Yesterday

Hi,

I'm looking for the best JQL for 2 different queries:

1. Jira JQL Query for Issues resolved today 

2. Jira Query for issues resolved Yesterday

 

The best I've been able to find is something like :

project =IDYOUS and resolutiondate >= -1d ORDER BY KEY ASC

 

Is there no function in JQL for Today() or Yesterday()

 

I want to ensure I'm using the dates and NOT just taking 24 hours off the resolved date / time.

What is the best JQL to use ?

2 answers

1 vote
Alex Koxaras Community Leader May 31, 2022

Hi @Michael Green 

As @SriKumar P very well guided you on these specific JQL functions, I'll provide your queries

  1. resolutiondate >= startOfDay()
  2. resolutiondate >= startOfDay(-1) and resolutiondate <= endOfDay(-1)

 

Regards,
Alex

Thanks Alex !  Will give that a try !

Like Alex Koxaras likes this
0 votes
SriKumar P Atlassian Team May 30, 2022

Hi @Michael Green

Welcome to the Atlassian community. We understand that you are looking for JQL functions that can help you get Issues resolved Today and Yesterday. 

I was able to find the below function from Advanced search reference - JQL functions 

  • endOfDay()

Could you please check the above function and check if you are getting desired results? 

 

Regards,
Sri

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
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