Searching for issues that were not completed on time

[Gerardo Silva]

Hi JIRA experts,

How can I get the list of issues that were not completed on time?

I tried the query below, but I am getting an error message

status = Done and due > resolved

Date value 'resolved' for field 'due' is invalid. Valid formats include: 'YYYY/MM/DD', 'YYYY-MM-DD', or a period format e.g. '-5d', '4w 2d'.

Thank you in advance

[Nicolas Bourdages · Accepted solution]

The query you made doesn't respect the syntax, like the error tells you. In JIRA out of the box, you can't compare the results of two functions like that, unfortunately.

A quick, low-technology fix would be to export a query of your Done issues to Excel and do the comparison there.

Otherwise, that sounds like something you could script in a custom JQL function using the Scriptrunner plugin.

[Gerardo Silva]

Thank you for your prompt response. I knew that I was not respecting the systax but I had the hope that It would be an alternative to compare both fields like in other technologies such as SQL. Anyways, I really appreciate your help. I will take a look at the Scriptrunner plugin.

Cheers!