Hello all, I have a business user who is looking to build a JQL with the following requirements: * For comments created/modified within a date range (not issue created) * For a specific user (comment by, not assignee) * Show those issues. I used copilot and Atlassian AI to try and figure this out but nothing is working properly. Is this JQL possible with the available comment fields? Thanks, Jonathan

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

Looking for a JQL query to identify a user's comments within a comment created date range.

Jonathan Smith

Hello all,

I have a business user who is looking to build a JQL with the following requirements:

For comments created/modified within a date range (not issue created)
For a specific user (comment by, not assignee)
Show those issues.

I used copilot and Atlassian AI to try and figure this out but nothing is working properly. Is this JQL possible with the available comment fields?

Thanks,

Jonathan

Accepted answers

Samuel Gatica _ServiceRocket_

Hi @Jonathan Smith

This is not possible via standard Jira - but an app which enhances JQL search functions will be able to do this, such as Scriptrunner.

Here are some example: JQL Keywords

lastCommentedDate

The lastCommentedDate keyword can be used to search for issues based on the date of most recent comment.

assignee = currentUser() AND lastCommentedDate < startOfMonth()

status = 'In Progress' AND lastCommentedDate = '2016-10-14'

This keyword can be used with the JQL relative date functions and also the numeric comparison operators.

commentedOn

This keyword can be used to find issues that had a comment made on them on a particular date.

commentedOn = '2016-02-14' AND project = VALENTINE<br>project = APOLLO AND assignee = narmstrong AND commentedOn in ('1969-07-20', '1969-07-21')

The commentedOn keyword can be used with the following operators: in, not in, != AND =

commentedBy

The commentedBy keyword can be used to search for issues that have comments on them made by a particular user. You must specify a username:

reporter = currentUser() AND commentedBy = 'jsmith'

This keyword can be used with the following operators: in, not in, != AND =

lastCommentBy

This keyword can be used to search for issues based on the user who made the most recent comment. You must provide a username:

reporter = 'jsmith' AND lastCommentBy = currentUser()

assignee = currentUser() AND lastCommentBy in ('jbond', 'jbauer')

This keyword can be used with the following operators: =, !=, in and not in

Best regards

Sam

All comments

Samuel Gatica _ServiceRocket_

Hi @Jonathan Smith

This is not possible via standard Jira - but an app which enhances JQL search functions will be able to do this, such as Scriptrunner.

Here are some example: JQL Keywords

lastCommentedDate

The lastCommentedDate keyword can be used to search for issues based on the date of most recent comment.

assignee = currentUser() AND lastCommentedDate < startOfMonth()

status = 'In Progress' AND lastCommentedDate = '2016-10-14'

This keyword can be used with the JQL relative date functions and also the numeric comparison operators.

commentedOn

This keyword can be used to find issues that had a comment made on them on a particular date.

commentedOn = '2016-02-14' AND project = VALENTINE<br>project = APOLLO AND assignee = narmstrong AND commentedOn in ('1969-07-20', '1969-07-21')

The commentedOn keyword can be used with the following operators: in, not in, != AND =

commentedBy

The commentedBy keyword can be used to search for issues that have comments on them made by a particular user. You must specify a username:

reporter = currentUser() AND commentedBy = 'jsmith'

This keyword can be used with the following operators: in, not in, != AND =

lastCommentBy

This keyword can be used to search for issues based on the user who made the most recent comment. You must provide a username:

reporter = 'jsmith' AND lastCommentBy = currentUser()

assignee = currentUser() AND lastCommentBy in ('jbond', 'jbauer')

This keyword can be used with the following operators: =, !=, in and not in

Best regards

Sam

Jonathan Smith

Sam,

Thank you for the feedback!

Jon

Jimmy Branton_ah6krf

Why is it that every time I want to look something up in JIRA it requires a plugin? So frustrating.

Ambar Canonicco

yes, and my organization won't allow it

Bartek Szajkowski _ Orbiscend OU

Hello @Jonathan Smith

I'm Bartek, from Orbiscend OU - ARGON app provider
If you are open for third-party app, I could suggest to check ARGON solution.

With ARGON’s commented function this is possible. You can filter issues based on comment author, comment date range and content, independent of issue creation date.

Example 1 – comments by a specific user within a date range:

issue in commented("project = ABC", "John Smith", "2024/01/01", "2024/01/31")

Example 2 – comments by a user in a date range with additional issue filtering:

issue in commented("project = ABC AND status = Done", "John Smith", "2024/01/01", "2024/01/31")

ARGON Powerful JQL Search

Hope my late answer will be useful for you

Greetings

Bartek

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-cloud

jql