Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL to find all tickets where a group of users add a comment during a specific time frame

VirtuallyTD
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 18, 2019

Im Trying to work out the JQL to find all tickets where a group of users have added a comment in the last month. Is this possible?

Ive tried a couple of things, for example: 

issue in commentedAfterDate("2018/10/19") AND  issue in commentedByUser(user01)

but cant work out the group and it brings back random results so obviously something wrong.

2 answers

0 votes
Muhammad Ramzan(Atlassian Certified Master)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 24, 2019

There is no straightforward way to do that, this  plugin can help you to find the required results. 

 

Here is the query which will return the required results.

 

issue in commentedBetween("2019-07-01", "2019-07-24") and issue in commentedByUser("membersOf(jira-administrators)")

 How to use

 

issue in commentedBetween("startdate", "enddate") and issue in commentedByUser("membersOf(groupname)")
0 votes
Muhammad Ramzan(Atlassian Certified Master)
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 23, 2019

Sorry for late reply , but here is the query which you are looking for , supported by plugin.

 

issue in commentedByUser("membersOf(jira-users)" ) and issue in commentedBetween("2019-07-21", "2019-07-27")

 

issue in commentedByUser("membersOf(groupname)" ) and issue in commentedBetween("startdate", "enddate")

how to use 

 

There are lot of other queries to get the comments , you can find the documentation

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-CommitsCount

asda.png

 

CommentedBetween

CommentedBetween can be used to find issues with comments added between particular dates. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY

issue in commentedBetween("2018-05-26", "2018-07-01")

 

CommentedOnDate

CommentedOnDate can be used to find issues with comments added on particular dates. Expected date format is yyyy-MM-dd (year dash month dash day of the month) or dd-MM-YYYY

issue in commentedOnDate("2018-05-26")

 

CommentedByUser

CommentedByUser can be used to find issues with comments added by a particular user (username is expected)

issue in commentedByUser("filip")

This function can be used together with membersOf to find issues commented by users who are members of a particular group.

issue in commentedByUser("membersOf(employees)")

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events