How can I filter for all issues where I have commented?

Nabil Suleman August 20, 2013

Is it possible to filter for all issues where I have commented. It doesn't matter what I comment, but I am trying to search for all issues where it is something like "commented by = currentUser()"

I am using JIRA version (v5.2.11#854-sha1:ef00d61)

Thanks,

Nabil

10 answers

1 accepted

9 votes
Answer accepted
Taiwo Akindele
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 20, 2013

Hi Nabil,

This is not available by default in JIRA, but you should be able to do this by installing the Script Runner Plugin. This will allow you to run a jql query like this:
issueFunction in commented("by username")
in JIRA advanced search.

You may refer to the following for further reference:

Regards.

Dan Tork February 2, 2021

Atlassian "This Is Not Available By Default" Jira... strikes again!

Like # people like this
Chris Smyrniotis October 24, 2022

why accept the answer that says you can't do this, when the 2nd answer below shows how you can almost entirely do this?

26 votes
Jake Bohall June 20, 2018

I created a filter for this search 

(summary ~ currentUser() OR description ~ currentUser() OR assignee = currentUser() OR worklogAuthor = currentUser() OR comment ~ currentUser() OR watcher = currentUser() OR text ~ currentUser() OR creator = currentUser() OR voter = currentUser()) AND status != done ORDER BY lastViewed DESC

To show me everywhere I'm mentioned and the ticket isn't done

Deleted user July 13, 2018

I would add Status Changed BY currentuser() too. I dont know if that is covered on yours

Like # people like this
Steven April 12, 2020

I added "assignee was currentUser()" as well:

(summary ~ currentUser() OR description ~ currentUser() OR assignee = currentUser() OR assignee was currentUser() OR Status Changed BY currentuser() OR worklogAuthor = currentUser() OR comment ~ currentUser() OR watcher = currentUser() OR text ~ currentUser() OR creator = currentUser() OR voter = currentUser()) AND status != done ORDER BY lastViewed DESC

Like # people like this
Dan Walker April 23, 2020

Great solve, +1 thanks!

Hoshea Rosenberg June 9, 2020

Is this still working for you? im not getting any results- possibly due to recent change to "user" display name GDPR stuff...?

Any part of the query that doesnt translate into an actual "assignee" (i.e. Assignee, creator, watcher etc) doesnt return a result.

This to me shows that its having trouble identifying currentUser() as a "mention" rather than an assigned user.

Like Barb O'Connell likes this
Hoshea Rosenberg June 20, 2020

Update- the response I got on support ticket I opened is that "~" currentUser() is not supported (in Cloud at least) for anything other than "=" anymore- the documentation has apparently been updated to show that...

I'd be happy to hear if anyone has ideas for an alternative...

Gianluca - STAGIL July 20, 2020

Hi Hoshea,

Uhm sounds strange. I've tried to copy/paste the JQL originally written by Jake and It works on my cloud instance. 

It accepts ~ as well:

jql.JPG

Hoshea Rosenberg July 20, 2020

Hey Gianluca, 

Yeah, the query is green as in"valid", but is it returning an expected result?

I wasnt getting any actual relevant query results... 

Gianluca - STAGIL July 20, 2020

Interesting. Yes, I'm getting the expected results

Hoshea Rosenberg July 20, 2020

the original query gives results because it includes XXX=currentUser (assignee = currentUser(), etc) as well as XXX ~ currentUser (text ~ currentUser(, etc)... If you remove all "=" from the query, there are no results...

8 votes
sumit kumar July 12, 2017

Looks like question Not active, still may help New vistiors.
Try Without using Any plugins :)

@Nabil as you are looking for where you have commented.
One Simple Workaround in JIRA is to looks for your Proflie.

1. Go to your profile, Navigate to Top Right Corner of the page
2. Check Activity Stream for the user (This will List all activities and comments)
3. Similary JIRA will give Links to other user profiles whenever they are Tagged/Mentioned and you can check comments or activities by other users.

May Not be directly applicable to all as depends on the use case, still hope this helps as no additional plugins are needed for this.

Regards,
Sumit

 

Steve Estes March 12, 2018

Thank you!  This is all I was really trying to do - show the issues I've updated, usually via comment.  Was really not relishing installing a plugin just to get that search function :)

Like sumit kumar likes this
Mow Das May 9, 2018

Thanks a lot for the solution. Really helped me sort out my tickets.

Like sumit kumar likes this
Christopher Morrow June 21, 2019

Should this still work? My profile contains no such link.

Allison Balla July 5, 2019

Very helpful.  Thank you!

Like sumit kumar likes this
Jonathan Thompson June 27, 2020

Tried this on mine. Would have worked but it only displays 25. I need to go back over 200 or so tickets to find the one comment I need to remove as it no longer applies. I am on dozens of projects and create, read, update, and delete dozens of tickets per day. So close!

1 vote
Andrey Markelov
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.
September 4, 2013
0 votes
Jason Hibbs August 23, 2023

Hi, is this native yet

0 votes
Enrico Deotto June 15, 2021

This is what worked for me. 

I added a custom field of type "People" to my ticket and I called it 'Commented by'. 

next I inserted an automation rule triggered by a 'ticket commented' event and I added a custom action that updates the 'Commented by' field as follows:

{
  "update": {
    "Commented by" : [
      {
        "add": {
        "id":"{{issue.comments.last.author.accountId}}"
      }
      }
    ]
  }
}

With this rule, every time a ticket  is commented, the commentator is appended to the 'Commented by' field. In other words, all tickets have the list of all the people who have commented them. 

This said, it's very easy to use this 'Commented by' field in a query to extract all tickets commented by me or any other user. 

0 votes
Houtan "Hobbe" Houshmand February 21, 2020

I'd like to do the opposite, show tickets where I'm NOT the latest comment.

 

I need to filter all tickets where i need to respond.

Have an automation for this that sets the status to "waiting reply from customer" and "waiting for my reply", but that only works on tickets created after the rule.

 

Any ideas?

0 votes
Veronika Dvorska December 12, 2019

Hi, please,

can I make a filter (jql) to search comments by name of user? like:

"project = "XYZ" AND issueFunction in commented("by curentUser")"

It gives me a list of issues where the user has commented but I wanna know how many comments exactly the curent user have in project

If there is a possibility to get the filter into a gadget, it would be perfect.

Please, any advice?

Thankx

 

Veronika 

0 votes

You can use Jira Comment Toolbox to filter issues according to comments with new JQL functions listed below.

    • Commented By User
    • Commented By User Between Dates
    • Commented By Group Member
    • Commented By Group Member Between Dates
    • Commented By Role Member
    • Commented By Role Member Between Dates

Moreover, You can contact with info@kostebekteknoloji.com for your new JQL function requests and comment functionality. 

0 votes
Timothy
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.
August 20, 2013

Not sure if that functionality exist at the moment.

Suggest an answer

Log in or Sign up to answer