How to get LAST Closed Date

[Tammy Robinson]

I am using the below logic to create a scripted field for Date Closed.  I cannot go back into all of our workflows and add a post function for Date Closed at this point so I am calculating it.  However, some workflows allow users to re-open issues.  Is there a way to capture the LAST closed date? The below code captures the 1st time the status is set to Closed.

import com.atlassian.core.util.DateUtils
import com.atlassian.jira.issue.history.ChangeItemBean
import java.text.SimpleDateFormat
import com.atlassian.jira.component.ComponentAccessor

def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()

String closed = changeHistoryManager.getChangeItemsForField(issue, "status").find {it.toString == "Closed"}?.getCreated()
Date formattedDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(closed)

[Tuncay Senturk · Accepted solution]

Hello Tammy,

1. You can loop reverse after getting status changes with getChangeItemsForField and return the first "Closed" match. However, I recommend to use ID rather than String.
2. Simply you can use Enhancer Plugin's Status Date custom field and select "Last" to define the Last Closed Date customfield

Best

Tuncay

[Tammy Robinson]

Thanks for the reply, Tuncay.  I do not want to purchase a plugin for this. I thought there might be a simpler way to get the last Closed status.  I just don't know the syntax to the get the last item of the list using the find.  Any ideas? Or how to loop reverse?

[Tuncay Senturk]

Hello Tammy,

Just add reverse()

changeHistoryManager.getChangeItemsForField(issue, "status").reverse().find {it.toString == "Closed"}?.getCreated()

[Tammy Robinson]

Thank you so much!  That's worked for me.

[Tuncay Senturk]

You're very welcome Tammy

As I mentioned before, it is wise to use status ID rather than status name.

Best

[Khan Muhammad Mahfuzur Rahman]

Hello Tuncay Seenturk_Snapbytes_

How can I implement on cloud jira about your solution? Please give details.

[Tuncay Senturk]

Hello @Khan Muhammad Mahfuzur Rahman 

JEP has cloud support, here is the link.