Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,559,076
Community Members
 
Community Events
184
Community Groups

JQL query for comments for particular user

Hi,

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

8 answers

2 accepted

19 votes
Answer accepted

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!

Worked beautifully for me, thanks!

I wish I could give you +10!

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

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

Regards,

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

Nice trick. Thanks. 

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

Like # people like this

Goto your profile and copy value from Username 

9 votes
Answer accepted
JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Feb 04, 2013

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Feb 04, 2013

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 ;-) 

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

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?

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jun 23, 2016

ScriptRunner is no longer free sad

Like # people like this
2 votes
Naren
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Feb 04, 2013

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

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

Like # people like this
David Skreiner
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Jun 23, 2016

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.

Help its broken - please fix Atlassian 

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.

comment~rahul.ingle AND project = test

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

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.

 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events