what is the JQL for created = resolved

[Mark Rowlands]

I am trying to get a report of all incidents that where opened and closed on the same day. Is there any way to do this in standard Jira ( 7.5 or 8.0 )  

[Manon Soubies-Camy · Accepted solution]

Hi @Mark Rowlands

You can't do this in standard Jira, see this feature request: Add ability to compare date fields using JQL.

If you have ScriptRunner installed, you can use the DateCompare JQL function:

issueFunction in dateCompare("", "resolutionDate = creationDate")

Hope this helps,

- Manon

[Antoine Berry]

Hi,

I get this error when trying this exact JQL : 

Is this a bug ?

Anyway I can use 

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

instead I guess. 

[Manon Soubies-Camy]

Thanks for your feedback, then I guess the query should rather be:

issueFunction in dateCompare("", "resolutionDate = created")

 or:

issueFunction in dateCompare("", "resolved= created")

I can't test it right now so let me know if it works :)

[Antoine Berry]

I have made a few tests and these seem to work only if the issue is resolved within the same minute it was created, so I guess it is comparing up to the hh:mm format ?

[Manon Soubies-Camy]

That would be possible indeed, I can't find the confirmation within their documentation though. You may contact their support to ensure it's the expected behavior 

[Mark Rowlands]

ok, thanks Manon, I got the results i needed direct from the database, not optimal but whatever. 9600 bucks for scriptrunner just for this is not really justifiable ;-)

[Manon Soubies-Camy]

Glad it helped! If you only needed that one JQL, it's indeed a bit too pricy :)