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

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

Also look at script runner commented jql function:

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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.