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