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

meesala_chanukya
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 19, 2024

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

3 answers

0 votes
Matt Parks
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 19, 2024

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

0 votes
Uday Kiran Bhaviri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 19, 2024

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/

0 votes
Aaron Pavez _ServiceRocket_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 19, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events