Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

What is the easiest way to see all issues that have not had a comment in x amount of time?

Michael Linton Crawford
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!
September 7, 2019

How do you create a filter that shows you all issues that have not had a comment in the last x day .  I am a developer, and realize I could probably get this with a series of calls the the API, but just seems like there has to be an easy way to do this.

2 answers

0 votes
Muhammad Ramzan(Atlassian Certified Master)
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.
September 8, 2019

You can use JQL Search Extensions for Jira & reports plugin which helps you to get all issues with comments filters. 

 

examples

CommentedBefore can be used to find issues with comments added before particular date. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY

issue in commentedBefore("2018-05-26")

 

 

CommentedBetween can be used to find issues with comments added between particular dates. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY

issue in commentedBetween("2018-05-26", "2018-07-01")
0 votes
Inactive Stephen
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.
September 7, 2019

Hi @Michael Linton Crawford

Not sure its possible using normal JQL - you might need to consider an add-on.

An example is ScriptRunner which can cover this and a whole host of other comment-based queries. You can see a whole list of comment-based options for ScriptRunner here.

Alternatively you could try a comment-based app - such as CCC Last Comment or Comment Toolbox for Jira which add a field such as "Last Comment Date" which you can search by.

Worth looking on the Marketplace to see what best suits your needs - there are plenty of options :)

Ste

Suggest an answer

Log in or Sign up to answer