Update the custom date field when a last commented By Assignee

jira_admin_cu

Hi Team,

We have a scriptrunner listener to capture the date field when a last commented by assignee, the field date is updating when the ticket assignee is adding the comment, and same date and time adding to the "Assignee Last Comment Date" field , but its not updating when we are adding the comment to the ticket transitioning from one status to another status, is there anything we need add to the script or any oder was missed in this listener ?

 

 

 

import java.text.SimpleDateFormat

def issue = event.issue

def simpleDateFormat = new SimpleDateFormat('dd/MMM/yy h:mm a')

if (issue.comments && issue.comments.last() && issue.assignee) { // Check for null values

  def lastComment = issue.comments.last()

  if (lastComment.authorApplicationUser == issue.assignee) {

    try {

      issue.update {

        setCustomFieldValue('Assignee Last Comment Date', simpleDateFormat.format(lastComment.updated)) // Replace with custom field ID or name

      }

      log.info("Assignee Last Comment Date updated successfully.") // Informative log message

    } catch (Exception e) {

      log.error("Error updating custom field: ${e.message}") // Log errors

    }

  }

} else {

  log.debug("No comments or assignee found.") // Debug log for missing data

}

 

Ram Kumar Aravindakshan _Adaptavist_

Hi @jira_admin_cu

For your requirement, you must use ScriptRunner's Custom Listener along with the Issue Commented event.

Below is a sample working code for your reference:-

import com.atlassian.jira.component.ComponentAccessor
import java.text.SimpleDateFormat

def issue = event.issue

def commentManager = ComponentAccessor.commentManager
def comments = commentManager.getComments(issue)
def dateFormat = new SimpleDateFormat('dd/MMM/yy h:mm a')

issue.update {
    comments.each { comment ->
        if (comment.authorApplicationUser == issue.assignee) {
            setCustomFieldValue('Latest Commented By Assignee', dateFormat.format(comment.created))
        }
    }
}

Please note that the sample working code above is not 100% exact to your environment. Hence, you must make the required modifications.

Below is a screenshot of the Listener configuration:-

What this code does is that it reads through all the comment histories of an issue and will only extract the latest comment that the assignee of the Issue has added. From there, it will update the Date Time file with the Date and Timestamp when the Issue was updated.

I hope this helps to solve your question. :-)

Thank you and Kind regards,
Ram