How to find all tickets i commented on between a certain period

[Matt B]

I want to find all tickets I left comments on between January 15th and March 31st of this year.  

If I cant do certain period, finding them all is fine if there is an order on them from older to newer or vice versa. 

Thank you!

[Kristopher Perez · Accepted solution]

Hey @Matt B ,

Welcome to the community! Jira natively does not support this kind of query in JQL. The closest you can get is with the ‘updatedBy’ keyword. 

https://support.atlassian.com/jira-service-management-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-updatedByupdatedBy--

heres an example of how it might work

• Find issues updated by John Smith between June and September 2021:
  issuekey IN updatedBy(jsmith, "2021/06/01", "2021/09/30")

Alternatively, if your instance has the Scriptrunner add on there are some additional keywords you get. See this question and answer here

https://community.atlassian.com/t5/Jira-questions/JQL-for-Commented-by-user-and-commented-date/qaq-p/1410972

[Matt B]

Thank you! Link had what i needed

[Jens Schumacher - Released_so]

Hi @Matt B ,

That query is not possible out of the box. However, there are a couple of 3rd party apps that provide this functionality. You can find more details in the following thread: 

https://community.atlassian.com/t5/Jira-questions/JQL-for-Commented-by-user-and-commented-date/qaq-p/1410972

Cheers,
Jens

Released.so - Release notes powered by Jira

[Bartek Szajkowski _ Orbiscend OU]

Hello @Matt B 

I'm Bartek from Orbiscend OU - ARGON app provider

If you are open for third-party app, ARGON ARGON Powerful JQL Search could be helpful in this case.

The Commented function allows you to search for issues that have comments matching specific criteria, such as content, author, or time period.

In your case, you could try finding issue with comments in date range:

issue in commented("project = SER", "", "2023/01/01", "2023/05/01")

Also you could use ex. function containing specific text:

issue in commented("project = SER", "", "2023/01/01", "", "urgent")

Greetings
Bartek