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

Ticket search for recent ticket comments (JQL)

Bill Parlock

I am trying to do search for tickets that have not been commented on in the current month. I managed the JQL for that. The challenge is I need to do the search, ignoring any comment from a certain user (management aka "UserA"). So a ticket might have 2 comments, the last comment by "UserA" and previous to that from someone else, I would like to ignore the "UserA" comment and and determine if the previous comment was made before the current month.

I do not have any additional JQL plugins from the marketplace.

Here is my current JQL I have been working on:

PROJECT = "MyProject" and ( issueFunction not in commented("by UserA") and (issueFunction in lastComment('before startOfMonth()' ) )

Any suggestions would be welcome. I am not sure this can be done.

Accepted answers

Joseph Chung Yin

@Bill Parlock -

It looks like you are using ScriptRunner for Jira. Take a look at the at this vendor link which I am sure you already did - https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/comments

Try something like -

project = MyProject and issueFunction not in commented("after -4w by UserA")

This should give you the result of finding issues commented not by UserA within the last 4 weeks.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Bill Parlock

Thank you for your help and suggestion to contact Scriptrunner. Here is the final JQL:

issueFunction not in commented("by UserA") AND issueFunction in lastComment("before -4W") AND project = "MyProject "

All comments

Joseph Chung Yin

@Bill Parlock -

Try something like -

project = MyProject and issueFunction not in commented("after -4w by UserA")

This should give you the result of finding issues commented not by UserA within the last 4 weeks.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Bill Parlock

Thank you. I will give it a try.

Joseph Chung Yin

@Bill Parlock -

Keep me posted of your testing result. If my suggestion helped you, please click on Accept answer when you have a chance.

Best, Joseph

Bill Parlock

The results will give me any issues not commented by UserA in the last 4 weeks. This is part of what I am looking for. So in addition, I am looking for issues with no comments for the last 4 weeks. So basically I am looking to exclude any comments by UserA, and then determine the tickets that have not been commented on in the last 4 weeks.

Bill Parlock

Thank you for your help and suggestion to contact Scriptrunner. Here is the final JQL:

issueFunction not in commented("by UserA") AND issueFunction in lastComment("before -4W") AND project = "MyProject "

Joseph Chung Yin

@Bill Parlock -

I am glad that my suggestion helped you at the end. Please also click on Answer accepted on my original postings when you have a chance.

Best, Joseph

jun lee_67lcq1

I used jql as like issueFunction in commented('by username'), but some issues are included in queary result. For example, person A commneted to jira issue #1, 2, 3, 4, 5 but the results of the inquiry are only included in 1, 2, and 3.

Do you know why?

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-service-management

jira-service-management-server