How can I find the tasks that are moved to Done Status after the Due date last month?

[Deepak Suresh]

I am trying to find the list of tasks which are moved to Done status after the Duedate in August month.

Can someone help me with the JQL?

[Mehmet A _Bloompeak_]

Hi @Deepak Suresh ,

You can try Status Time app developed by our team at Bloompeak. It provides various reports. One of them is status entry dates. You can list status entry dates as well as resolution dates of issues with a jql like 'status changed AFTER endOfMonth(-1) and status = done' and export the report. Then you can compare the two dates.

Here is the online demo link, you can see it in action and try. Hope it helps.

[Iago Docando]

The JQL can't compare by itself if duedate>resolutionDate, wich is what you want.

You can, however, use a plugin/app to create a custom scripted field (lots of options in the market, check out myGroovy, for example) so this custom field returns 1 if the condition is met and 0 otherwise.

The JQL would then simply be something like:

status changed AFTER endOfMonth(-1) and status = done AND cf_00000 = 1

Hope it helps

[Jason Galea]

Hi @Deepak Suresh ,

This should help:

status changed AFTER endOfMonth(-1) and status = done

Cheers,
Jason

[Deepak Suresh]

No. I mean.. each tasks have a specific due date. I want to find the list of over due tickets in last month..  I mean the tickets which are moved to done status after the task's due date.

[Deepak Suresh]

Currently those tickets are in closed status.. and some are still in done status..

I list want to find which tasks are delivered after the due date.