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; } } }

How to see the treatment closed on the day of creation?

Никита Марасинский

Hello, guys!
I need help.
How can i see all issues where createddate=resolutiondate?
use search JQL

Accepted answers

Thomas Magny-Garcia

Hi @Никита Марасинский
Be careful of the data type you want to use, createdDate is not a data of the type "datetime". This type use the day but also the hour of the event.
Maybe you can use something like :

issueFunction in dateCompare("", "created +1d > resolutionDate ")

to find issues that the resolution date is less than 24h after the creation date.

All comments

Ravi Sagar _Sparxsys_

Hi @Никита Марасинский

Not out of the box.

What you can do instead is use the following JQL with both the columns side by side in your Issue Navigator. Not ideal.

ORDER BY resolved ASC, created ASC

There are ways to do that using an add-on too.

Ravi

Thomas Magny-Garcia

issueFunction in dateCompare("", "created +1d > resolutionDate ")

to find issues that the resolution date is less than 24h after the creation date.

Никита Марасинский

Yeah, its working!
Thank you so much!

Никита Марасинский

Yeah, i know some SQL functions, but i need this query for JIRA Desktop.
Anyway, thanks)