JQL Query - How to retreive all the tickets a specific person added comments to ?

Question

Hello,

Need some help with JQL QUERY:

Several tickets I've been working on have been assigned to different other users.

I would like my search results to display ONLY tickets I wrote a comment on.

I am not a reporter nor an assignee.

Thanks for your help

mauricio.groth · Answer

Hi @Johanna Metzger,

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.
With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all the tickets a specific person added comments to.

commentedByUser = "Johanna Metzer"

Check out the documentation for more examples.
I hope this helps!
Maurício

Esabel Gomez · Answer

You can try to pull up issues updated by yourself (this includes anything you commented on). However you will get results for everything you updated/created.

JQL:

updatedBy(user)

updatedBy(user, dateFrom)

updatedBy(user, dateFrom, dateTo)

For more info see: https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#:~:text=top%20of%20page-,updatedBy(),-Search%20for%20issues

Trudy P Claspill · Answer

That is not a feature natively available in the Jira searching functionality. You will have to look for a third party app that extends the search capabilities to support that.

There were issues in the Atlassian backlog requesting this feature which they have indicated they will not implement.

Jira Server: https://jira.atlassian.com/browse/JRASERVER-1648

Jira Cloud: https://jira.atlassian.com/browse/JRACLOUD-1648