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

Question

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.

Muhammad Ramzan_Atlassian Certified Master_ · Answer

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 , "2018-07-01")issue in commentedBetween("2018-05-26"

Inactive Stephen · Answer

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