nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Michael Green_am0a50

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 ?

Accepted answers

Alex Koxaras -Relational-

Hi @Michael Green

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

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

Regards,
Alex

All comments

Sri Kumar_10fwob

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