Hello all,
I have a business user who is looking to build a JQL with the following requirements:
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
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
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.
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=
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 =
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
Sam,
Thank you for the feedback!
Jon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.