populate JIRA tickets uncommented for more than 2 days by my team

[meesala.chanukya]

How do I populate the list of JIRA tickets using quick filters which are not commented by my team in the last 2 days

[Matt Parks]

If you have ScriptRunner, they have an issuefunction around comments

As a quick example, the following query would return all issues where a user with a username of ukb hasn't commented in the last two days

issuefunction not in commented("after -2d by ukb") - this will go back exactly two days.

issuefunction not in commented("after startOfDay(-2) by ukb") - this will go back to the beginning of two days ago.

You can also set it up to look for any user with a specific role.

Documentation:  https://docs.adaptavist.com/sr4js/8.11.0/features/jql-functions/included-jql-functions/comments#commented

[Uday Kiran Bhaviri]

Am just assuming it is for a JSM project.

If your team is working on the issues and if they are agents they may add the comment ask for clarification and change the original status to 'waiting for information' or similar status or they can close the request by providing the right solution or answering the question again the status will change here from original status to 'Completed'.

So the status change is common here,  you can define SLAs for status changes and is not updated from last 2 days or so... You can send notification or alerts to the team or agents.

Define SLA -

https://support.atlassian.com/jira-service-management-cloud/docs/create-service-level-agreements-slas/

Using SLA s in JQL - 

https://support.atlassian.com/jira-service-management-cloud/docs/write-jql-queries-for-slas/

[Aaron Pavez _ServiceRocket_]

Hi @meesala.chanukya 

Sadly you cannot run the JQL against the comment itself. The comment only allows this:

comment !~ EMPTY or comment ~ EMPTY.

So you need to look for Jira issues that haven't been updated in the last two days.

Updated <= -2d

But this won't work if the status or any other field has been updated in the last two days.

For your use case, you need to use a third-party plugin.

JQL extension might help:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3375124/JQL+aliases+and+functions+reference#CommentLastUpdatedOnDate

Regards