Date of last update on a custom field

[Jorge]

Hello!

I need some help with grabbing the date (yyyy-mm-dd) of the last time a custom field was updated, nothing fancy just the date to display it on a dashboard for managers.

I appreciate the help.

[Mark Segall · Accepted solution]

Hi @Jorge - Jira does not provide a native mechanism to query against history so you'd need a 3rd party tool like script runner.

[Jorge]

Thanks, I was able to pull this of with Scriptrunner

[Judah]

@Jorge - How did you do this with ScriptRunner? 

[Jorge]

Hi Judah,

I used a script field:

import com.atlassian.jira.component.ComponentAccessor

final String customFieldName = "Your_custom_field_name"

def changeHistoryManager = ComponentAccessor.changeHistoryManager

def changeHistory = changeHistoryManager.getChangeItemsForField(issue, customFieldName)

log.warn(changeHistory)

try{

def changedate = changeHistory.last()?.getCreated().getDateString()

log.warn(changedate)

return changedate

}

catch (Exception e){}

[Judah]

@Jorge Thanks for sharing your code! I also used a SR Scripted Field: Date Time Range picker, Custom template (so I could manipulate the date format), I also added some logic to hide the script field if another field has no value.  

Custom Template: 

$datePickerFormatter.withStyle($dateTimeStyle.DATE).format($value).toString()

Script: 

import com.atlassian.jira.component.ComponentAccessor

// To get the Status Comments field

def statusCommentsField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectsByName('Status Comments')[0]

// To get the Status Comments field value for an issue

def statusCommentsValue = issue.getCustomFieldValue(statusCommentsField)

// To get the Status Comments field's changes 

def lastComment = ComponentAccessor.getChangeHistoryManager().getChangeItemsForField(issue, 'Status Comments')

if(!statusCommentsValue){ // If Status Comments field is empty or has no value

    return null

}else{

    if(lastComment){ // If the Status Comments field has change history record(s)

        return lastComment.last().getCreated()

    }

}

[Jorge]

Nice work!