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

[Samuel Gatica _ServiceRocket_ · Accepted solution]

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

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