Need JQL Script for extracting date on which all issues came in In Progress State

[Charu Sharma]

Need to pull out report for all issues with date on which they were transitioned to In-Progress and Done.

[Alexey Matveev · Accepted solution]

Hello,

JQL can retrieve only issues. If you want to show a date, on which an issue was transitioned from In-Progress to Done, you need to create a custom field.

You can create a custom field, called Transition Date and fill it automatically on the In Progress to Done transition. You can create an Update Custom Field post function for this transition and set current date for this field. You can find more info here:

https://community.atlassian.com/t5/Jira-questions/How-do-I-set-a-custom-field-with-the-current-date-time-in-a-post/qaq-p/143415

Then you can add this field to your search result.

[Charu Sharma]

Thank you very much Alexey.

I tried it for demo project, it works just as we need it.

[Alexey Matveev]

If my answer helped, kindly accept my answer as accepted.