Write a query to find comments added by a user after a specific date ?

Question

I want to find all jira issues in which a comment was added by a specific user after a specific date.

I created a jql like this

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

so basically, I want to see comments added by "admin" only after 2018/10/19 date. But I am getting results even if the comment was added prior to that date. What can I do to fix this query.

Jeff Boschee · Answer

With scriptrunner, the following JQL query should work for what you're asking for:

issueFunction in commented("by user.name after 2020/02/19")

Petter Gonçalves · Answer

Hello Ashbal,

The syntax of the query you are performing is working like this:

- issue in commentedAfterDate("2018/10/19") - The issue was commented after 2018/10/19, however, not necessarily by the user Admin

- commentedByUser(admin) - The user admin commented on the issue, but not necessarily after 2018/10/19

As you can see in this documentation, In order to correlate both parameters and return all the issues commented by Admin after 2018/10/19, you must configure the following query:

- issue in commentedAfterDate("2018/10/19","admin")

Please, let me know if it works for you, Ashbal.