How can i create a JQL query for the issues that don't have any new comments after certain time?

[Natalia Mojica]

Heyyy. I want to create a filter where i can see only the tickets that dont have any new comments after 72hours. 

At the moment, I have a filter for the tickets that dont have an update for their status after 72h (NOT status changed after -72h), and I want a similar query, but for tickets that do not have new comments in that same period of time

[Jeroen Poismans · Accepted solution]

Hi Natalia,

There is a way you can do this but as Jan already mentioned, it is not an out-of-the-box JQL feature but it gets the job done :-).

• Create a Last comment date field (DateTime)
• Create an automation rule for the appropriate project(s)
  • Trigger: When issue commented
  • Edit issue: Set the Last comment date  field to {{now}}

Now you can build a JQL that gets you the issues where Last comment date  has been > 72h ago.

Good luck!

Jeroen

[Charlotte Santos -Appfire-]

Hi @Natalia Mojica

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all the tickets that don’t have any comments after 72 hours:

commentLastUpdatedOnDate < -72h

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

[Jan-Hendrik Spieth]

Afaik, this is only possible with addons, such as "JQL search extensions", Scriptrunner, and others.

Hope this helps ;-/