JQL query for comments for particular user

[jayanth thimmaiah]

Hi,

we want list comments added by particular user in a project/Issue ,is it possible to get by JQL ?

[Jamie Echlin [Adaptavist] · Accepted solution]

You can try script runner and use the jql issueFunction in commented ("by username")

Can't point you to the docs at the moment because the site is being moved.

[Renjith Pillai]

Hey Jamie. Saw that movement. Need a hand to get some editing/formatting of the pages? (saw some invalid macros)

May be you can set the default confluence theme for documentation as well.

[Amy Bell]

A cool workaround I found for pulling relatively smaller lists of tickets that a user updated (such as commented on):

Add an Activity Stream gadget to a dashboard - and then click Edit in upper right.  Add a Global Filter:

"Username" "is" "(username)"

Viola!

[Morgan Heijdemann]

Worked beautifully for me, thanks!

[Mats Nordgren]

I wish I could give you +10!

[TJ Tripp]

This worked amazingly well for some quick clean up I needed to do.

[Rivo Tahina Razafindratsifa]

Thanks ! It works like a charm. Is there any way to export the result ?

Regards,

[Tommy Rowe]

This isnt working, and hasnt for a bit - Anyone heard any news on this being broken?

[Clément Grimal]

I installed the following free add-on: "Script Runner"

Then, you can use the following query

issueFunction in commented("by username")

as described in the documentation: https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-commented(commentquery)

[David Skreiner]

ScriptRunner is no longer free 

[Naren]

You can use the JQL Tricks plugin . Use the issue function commentedByUser([User]) to find the list of comment added by particular user

[jayanth thimmaiah]

JQL Tricks plugin is paid, do we have any altrenatives ?

[David Skreiner]

As a workaround, you can use a dashboard:

1 open Dashboard
2 Add Gadget Activitiy Stream
3 Add a global filter: Project is XY
4 Add a global filter: User is (username)
5 Below the Global Filter, klick JIRA - Add Filter:  Activity is Comment
6 Set "limit to 99 items"

You now have the comments as an activity stream.

[Tommy Rowe]

Help its broken - please fix Atlassian 

[Mert Karadağlı [KOSTEBEK TEKNOLOJI]]

You can use JIRA Comment Toolbox plugin.

You can find the list of the issues which is commented by current user , selected user, group member and role member and you can limit this search with comment date or last comment.

If you need any custom JQL for comments you can also contact with us, mailto:info@kostebekteknoloji.com.

[John Gooch]

Even better,  this JQL works for me. you can reduce it to only the parameters that interest you.

(summary ~ currentUser() OR description ~ currentUser() OR comment ~ currentUser()) and updatedDate >= -7d

[Lesa King]

I am unable to return the ticket Comments field with this or any other query. Like the original request, that is what I need: a list of comments.  Is there something I am not seeing that allows me to select that field in the results?

[Jason Kovacs]

This might help someone find all issues with comments across multiple users, though you have to go to each detail to see them.

Use this JQL advanced filter for the All Issues list:  comment !~ "junktext"

This returned all the issues that have comments because they do not contain "junktext".