Create a report/dashboard to see if Assignees have or have not responded?

[Kashif Saleem]

Is it possible to create a report or dashboard for managers to view which people, i.e. assignees in their org have or have not responded to tickets they have been assigned?

[Pablo Beltran]

What does it mean "responded"?

As @Elifcan Cakmak suggests, it might mean that the issue has been "commented" by the assignee.

But it might also be interpreted as the assignee has changed the status. In this case, you have to access the historical changes in the issue and get the date when the assignee changed. Then search for a posterior status change.

SQL+JQL Driver supports all of the use cases above (get issue comments and/or the history of changes for assignee and status fields) as well as display the results on Jira Dashboards.

[Elifcan Cakmak]

Hello,

You can create a filter by using "issueFunction in" function of Script Runner add-on. However as far as I know you can't use it with "assignee" but only with usernames such as:

issueFunction in commented("by elifcan")

You can specify it by using like this:

issueFunction in commented("by elifcan") and assignee  = elifcan 

But still you would need to search one by one for users.

Regards,

Elifcan

[Kashif Saleem]

Hi @Elifcan Cakmak thanks for the help. So, issuefunction seems be of some help. I say some, because i'm actually looking at any update to a ticket when specific person was assigned to it. They don't necessarily have to be the last person either. Any ideas how this could be expanded?

[Elifcan Cakmak]

Hello,

Sorry for the late response. Could something like this work for you then?

(assignee was in ("elifcan") AND status changed) OR (issueFunction in commented("by elifcan"))

or

(assignee was in ("elifcan") AND status changed FROM "To Do" TO "In Progress") OR (issueFunction in commented("by elifcan"))

Or you could try a plugin like @Pablo Beltran suggested but I don't have any experience with it, so I cannot say anything specific about it.

Regards,

Elifcan