Filter on when an issue was commented on.

Stu January 2, 2019

Hi, I keen to get some JQL for a Quick Filter that will enable me to display which issues haven't had a new comment added to them for 20 days.

Any thoughts?

Thanks in advance

1 answer

1 accepted

1 vote
Answer accepted
Nir Haimov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 2, 2019

Hi,

This:

!(commentedOn >= startOfDay(-20))

Will give you all issues that have comments, but not in the last 20 days.

If also want issues without comments at all add

commentedOn is EMPTY

 

So your funal JQL is:

!(commentedOn >= startOfDay(-20)) OR commentedOn is EMPTY

 

Johan Soetens _Dumblefy_
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.
January 2, 2019

Very handy but commentedOn is not an out-of-the-box feature, it's from Adaptavist Scriptrunner

Like Stu likes this
Nir Haimov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 3, 2019

Yeah, forgot to mentioned it, there is no built in solution in Jira, you can achieve this only with add-ons, Scriptrunner is one of them

Like Stu likes this
Stu January 3, 2019

Great - thanks guys, I already have ScriptRunner.  cheers

Suggest an answer

Log in or Sign up to answer