nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ScripRunner - Script Fields Last Comment Date By Agent And Customer

David Harkins

Has anyone done or know how to script two fields, showing the date of the last comment on an issue by a Service Desk agent and a Service Desk Customer.

So two separate fields with two dates, giving an indication of who was the last to comment and how long ago. i.e. is this something the we should be chasing up with the customer or have we let an issue slip behind.

Accepted answers

David Harkins

And a working version :-)

import com.atlassian.jira.component.ComponentAccessor

def commentManager = ComponentAccessor.commentManager
def comments = commentManager.getComments(issue)
def groupManager = ComponentAccessor.getGroupManager()

def sortedComments = comments.toSorted {a, b -> b.created <=> a.created }

for (comment in sortedComments) {
 if (groupManager.getGroupNamesForUser(comment.authorApplicationUser).contains("jira-servicedesk-users")) {
 return comment.created
 break
 }
}
return null

All comments

Nic Brough -Adaptavist-

https://library.adaptavist.com/entity/show-last-comment-for-an-issue shows you how to get to a comment object, which you can ask for the created or updated dates, as well as the name of the author.

Note that "how long ago" is not scriptable - it's a moving target, so you'd have to be re-indexing constantly.

David Harkins

The how long would not be scripted in the field, but will enable queues to display issues that have not been commented on x days.

So we can get the name of the last comment author, if we need to get the last comment date by customer and the last comment date by agent, we would need to loop through all previous comments until a user match is made.

David Harkins

My progress so far:

import com.atlassian.jira.component.ComponentAccessor

def commentManager = ComponentAccessor.commentManager
def comments = commentManager.getComments(issue)

log.info("Comments:" + comments.size)

if (comments) {
 comments.each { comment ->
  log.info("Author" + comment.authorApplicationUser)
 }
}

David Harkins

The Following:

import com.atlassian.jira.component.ComponentAccessor

def commentManager = ComponentAccessor.commentManager
def comments = commentManager.getComments(issue)
def groupManager = ComponentAccessor.getGroupManager()
//def ReturnDate = date
int check = 0

//log.info("Comments:" + comments.size)

for (comment in comments) {
log.info("Author" + comment.authorApplicationUser)
if (groupManager.getGroupNamesForUser(comment.authorApplicationUser).contains("jira-servicedesk-users")) {
log.info("Author is A Service Desk Agent")
return comment.created
break
}

}
return null

is returning the first comment where the user is a service desk agent :-(

Gökçe Gürsel {Appfire}

Hi @David Harkins ,

As an alternative, you can use Enhancer Plugin for Jira for this.

It has a dedicated field called Last comment Date & Last commented User and Last comment. These fields are also searchable.

image2017-8-24+13-29-16.png

Please let me know if you have further questions.

Cheers,

Gökçe

Please note that I'm a member of the Snapbytes team who developed the Enhancer Plugin for Jira.

David Harkins

And a working version :-)

import com.atlassian.jira.component.ComponentAccessor

def commentManager = ComponentAccessor.commentManager
def comments = commentManager.getComments(issue)
def groupManager = ComponentAccessor.getGroupManager()

def sortedComments = comments.toSorted {a, b -> b.created <=> a.created }

for (comment in sortedComments) {
 if (groupManager.getGroupNamesForUser(comment.authorApplicationUser).contains("jira-servicedesk-users")) {
 return comment.created
 break
 }
}
return null

David Harkins

@Gökçe Gürsel {Appfire}

The plugin may provide the required function, but also has a lot more features, so is probably overkill for what I need at this stage. But thank you for your suggestion.

David Harkins

I changed the IF statement to a NOT to get last customer comment

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-service-management

jira-service-management-server