JQL query for comments for particular user

[tjayantha]

Hi,

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

[Amy Bell · Accepted solution]

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!

[Network Support]

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?

[Liz_Pat]

Nice trick. Thanks. 

[alon]

Can't make "Username" "is" "(username)" to work....  Tried different ways of filling  username:

• "Agent Smith"
• "agent smith"
• agent smith
• Agent Smith
• 5f59dc7ef0d30600f657dcff    (This is the user's Jira ID)
• All of the above with ( ) in \ out of the " "

Any ideas?

NOTE:
Jira won't auto complete the username as it does in the JQL filter

[Oleksandr Kulychok]

Goto your profile and copy value from Username 

[JamieA · 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.

[Кирилл Домасевич]

JamieA, thx a lot. Exactly what I'm looking for, not like a workaround approaches above ;-) 

[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?

[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

[tjayantha]

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 

[Luis]

Hola, existe alguna forma de auto asignar una incidencia a un usuario determinado de forma automatica? He realizado un filtro donde me muestra solo las subtareas hijas que ya estan en estado franqueadas, pero necesito que se asignen a un usuario en concreto de forma automática conforme esas subtareas vayan apareciendo. Es posible?

basicamente lo necesito para no tener que estar entrando en el filtro y tener que asignarlas yo manualmente a un usuario para que las gestione.

[Rahul Ingle]

comment~rahul.ingle AND project = test

[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".

[Mert Karadağlı _ Köstebek 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.