Best way to get time of issue being sent to done JIRA cloud api

[Meagan]

So I am trying to create a little tool for our team that will see when an issues moved to the done column. 

Currently I have:

/rest/agile/1.0/board/${boardId}/sprint/${sprintId}/issue?jql=status=Done&expand=changelog

 as the url to get all done issues with the changelogs. Then I parse the pages of change logs for when it was moved to done.  

Is this the best way to do this? Can I use jql on the changelog to only return status event changes so that I don't have to parse though the changelogs many pages?

[Trudy Claspill]

Hello @Meagan Hiatt 

If your workflow is setting the Resolution field when issues move to the Done column, and clearing that field if/when the issues are moved out of the Done column (i.e. reopened), then all you need to do is look at the ResolutionDate field to see when that change happened. If you set/clear the Resolution field as part of the transitions, that sets/clears the ResolutionDate field.

[Bill Sheboy]

Hi @Meagan Hiatt 

Yes, and...to Trudy's answer:

If you are not setting the Resolution as part of your workflow, you could instead use the statusCategoryChangedDate.  This field would be set as soon as the issue changes statusCategory for any status, such as to "Done"

Kind regards,
Bill