Filtering to last username that has performed activity change (status, comment, history)

Question

We are using a kanban board with a lot of customers. Since a lot of our customers are not using the status changes or assigning properly.

As a workaround I want to use card colors, to represent cards that require attention from us, or our customers.

The problem I'm encountering though, is that I can't properly filter on the last comment or activity on a ticket. It searches through the entire history of the ticket.

This is the query I'm using:

status changed BY membersOf("group")

Björn_lw1952 · Answer

Hey Petterson,

The function lastcomment is not supported in the Cloud version of Jira.

You get the following issue

Field 'issueFunction' does not exist or you do not have permission to view it.

Petter Gonçalves · Answer

Hello Björn,

Unfortunately, it's not possible to filter issues only based on its last comment, however, you should be able to do it using the Script JQL Functions provided by the Scriptrunner plugin.

The query would be simple:

lastComment(comment query)

You can check the documentation below for more details:

LastComment function

I hope this helps! Have a nice weekend.