How to query the time since a comment was added to an issue

[Chris Watson]

Hello,

I am trying to create an automation rule that checks the number of days since an issue was commented on/updated. It appears that the comment variables are setup to act as a trigger for the rule, rather than something that can be used for comparison.

My goal is to have a rule that will send out a notification if an issue has not had any comments added in 30+ days. I have all of the other pieces of this rule working, but I am not able to figure out how to check the comment piece. 

[Alex Koxaras -Relational- · Accepted solution]

Hi @Chris Watson and welcome to the community

You should create a rule like the following:

Pay attention to the checkboxes as well as on the JQL. You have to replace this with your own.

Let me know if you got this!

[Chris Watson]

Excellent, thanks for the help.

[Alex Koxaras -Relational-]

Kindly mark my answer as accepted in order to help others with similar  questions.  Thanx!

[Chris Watson]

It doesn't appear to be working correctly. I applied the change in syntax and when the rule ran it triggered on issues that had been updated 2 days ago.  Here is the syntax of my query. 

project = WMO AND status = "In Progress" OR status = "Pending Internal" OR status = "Pending Vendor" or status = "Approved" and updated <= startOfDay(-30)

[Alex Koxaras -Relational-]

@Chris Watson you have to use parenthesis in your clause for starters:

project = WMO AND (status = "In Progress" OR status = "Pending Internal" OR status = "Pending Vendor" or status = "Approved") and updated <= startOfDay(-30)

OR you can use:

project = WMO AND status in ("In Progress", "Pending Internal", "Pending Vendor", "Approved") and updated <= startOfDay(-30)

[Juan Carlos Vera]

You can see if there are comments added -30d with an alias that is part of a Plugin "JQL Search Extensions for Jira - the JQL extensions"

You can find issues that were recently commented on and order them by the comment date:

commentLastUpdatedOnDate < -2d order by commentLastUpdatedOnDate desc

I think that is free for 10 users.

You can see more info here:

JQL aliases and functions (reference) - JQL Search Extensions - Confluence (atlassian.net)