how can i search to find all issues that had a Comment added within a date range (e.g. december 1 to 7)?

erika keohan January 21, 2013

how can i search to find all issues that had a Comment added within a date range (e.g. december 1 to 7)?

4 answers

3 votes
JamieA
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.
January 21, 2013

Also look at script runner commented jql function:

issueFunction in commented("after 2012/12/31 before 2013/01/07")

Abel Braaksma _admin_ December 9, 2019

Note that this is not quite right. Using ScriptRunner It will return all issues that have a comment after a certain date and before a certain date. Since the 'commented' function does not operate on a single comment, that means it will include issues that have, say, one comment from 2011 (before the date) AND one comment in 2014 (after the date).

The only way that I found to make sure a comment is made WITHIN the date range is to make the range explicit. In JIRA CLOUD you cannot use 'issueFunction in commented(...)', but you can write:

 commentedOn in ( '2016-10-01', '2016-10-02', '2016-10-03', '2016-10-04', 
'2016-10-05', '2016-10-06', '2016-10-07', '2016-10-08', '2016-10-09',
'2016-10-10', '2016-10-11', '2016-10-12', '2016-10-13', '2016-10-14',
'2016-10-15', '2016-10-16', '2016-10-17', '2016-10-18', '2016-10-19',
'2016-10-20', '2016-10-21', '2016-10-22', '2016-10-23', '2016-10-24',
'2016-10-25', '2016-10-26', '2016-10-27', '2016-10-28', '2016-10-29',
'2016-10-30', '2016-10-31') AND commentedBy = 'someUserName'

 

It's a bit clumsy, but it works. With large date ranges, this is not really feasible though.

Also note that, if you are just looking for "commented before" or "commented after", you can use:

commentedOn < '2016-01-31'

Or:

commentedOn > '2016-01-31'

Oh, and don't forget that you must synchronize your issues with ScriptRunner when in JIRA CLOUD, or none of this works. You can do that in the admin section.

1 vote
cweiske December 12, 2016
Mark Hostetler July 12, 2019

Atlassian: "Nah, y'all can pay for it..."

1 vote
Zul NS _Atlassian_
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 21, 2013

Take a look at this HP/Palm JIRA Search Plugin

JQL function that searches comments by author and date in addition to comment content.

MattS
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.
September 14, 2016

Is that still active?

0 votes
Andrey Markelov
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.
September 4, 2013

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events