nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Alex Koxaras -Relational-

Hi @Chris Watson and welcome to the community

You should create a rule like the following:

comm rule01.png

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!

All comments

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)

Alex Koxaras -Relational-

Hi @Chris Watson and welcome to the community

You should create a rule like the following:

comm rule01.png

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)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

jql

automation