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; } } }

JQL to identify issue which fields were modified but no comment was added

Hello,

I am trying to find a JQL to identify issues that were modified during the week (worklog added, attachement added, status changed) but no comment was added in the last three days. I came up with :

project = "XXXXX" and component = XXXXX AND status not in (Resolved,Closed) and updatedDate >= startOfWeek() AND worklogDate >= startOfWeek() AND status CHANGED AFTER startOfWeek() AND commentedOn >= -3d

It is perfect except for the fact that we don't have the Scriptrunner plugin so ''commentedOn'' is out of the question.

Any ideas for a workaround?

Thank you so much!

Accepted answers

How often do you need to run this query, as that may help you decide possible solution approaches?

One time: Run your existing query without the "commented on" check, and...

Manually look at issues histories and comments, or
Export the issues to a spreadsheet and use formulas to identify the last comment date/time

Often:

Investigate purchasing a marketplace addon, or
Using automation for Jira rules to log the last date/time a comment was made in a custom field.

Kind regard,
Bill

All comments

How often do you need to run this query, as that may help you decide possible solution approaches?

One time: Run your existing query without the "commented on" check, and...

Manually look at issues histories and comments, or
Export the issues to a spreadsheet and use formulas to identify the last comment date/time

Often:

Investigate purchasing a marketplace addon, or
Using automation for Jira rules to log the last date/time a comment was made in a custom field.

Kind regard,
Bill

Hi @Bill Sheboy

Thank you so much for your response. I appreciate you taking the time to do it.

Welcome!

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

Quick Links

Find more posts tagged with

server

issue

jira

jira-server

jql