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

[Johanna Metzger]

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]

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]

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 Claspill]

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