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 _Snapbytes_

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