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

[Thomas Magny-Garcia · Accepted solution]

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.

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

Yeah, its working!
Thank you so much!

[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

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

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