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

[Nabil Suleman]

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

[Taiwo Akindele · Accepted solution]

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:

• Script Runner Documentation
• Scripted JQL functions (Comments)

Regards.

[Dan Tork]

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

[Chris Smyrniotis]

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

[Jake Bohall]

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]

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

[Steven]

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

[Dan Walker]

Great solve, +1 thanks!

[Hoshea Rosenberg]

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.

[Hoshea Rosenberg]

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]

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:

[Hoshea Rosenberg]

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]

Interesting. Yes, I'm getting the expected results

[Hoshea Rosenberg]

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

[sumit kumar]

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]

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

[Mow Das]

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

[Christopher Morrow]

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

[Allison Balla]

Very helpful.  Thank you!

[Jonathan Thompson]

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!

[Andrey Markelov]

See https://marketplace.atlassian.com/plugins/ru.andreymarkelov.atlas.plugins.utils

I have implemented JQL functions

[Jason Hibbs]

Hi, is this native yet

[Enrico Deotto]

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. 

[Houtan "Hobbe" Houshmand]

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?

[Veronika Dvorska]

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 

[Mert Karadağlı _ Köstebek Teknoloji _]

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. 

[Timothy]

Not sure if that functionality exist at the moment.