Find all issues which commented by specific user

[Anh Nguyen]

Hi everyone, 

Could someone help me find all issues with JQL that have been commented on by a specific user? I tried using the filter below, but it also includes comments that mention the user.

comment ~ <USERID>

Thanks

[Hans Polder _Devoteam_ · Accepted solution]

@Nguyen tuan anh ,

Jira’s native JQL doesn’t support this directly. You can achieve this with the help of third-party plugins like ScriptRunner or JQL Search Extensions.

Here are some examples:

Using ScriptRunner:
issueFunction in commented("by username after 2023-01-01")
This query finds issues commented on by a specific user after a certain date.

Using JQL Search Extensions:
issue in commentedByUser("username")
This query finds all issues commented on by a specific user

[Anh Nguyen]

I want to find the other. But, There is no other way besides your solutions.  

Thank you sm @Hans Polder _Devoteam_ 

[Marvin Brand]

Hey @Hans Polder _Devoteam_ , any idea why "issueFunction in…" doesn't work on our cloud site? Script Runner Enhanced Search is enabled. Does "issueFunction in…" even still exists for cloud?

Thanks!

Marvin

[Hans Polder _Devoteam_]

Hi @Marvin Brand ,

You can't use the 'issuefunction' directly in the standard Jira Issue Search functionality. You'll need to go to Apps > ScriptRunner Enhanced Search and use that to filter accordingly.

Some inspiration: https://community.atlassian.com/forums/Jira-questions/The-issueFunction-JQL-search-is-not-working-in-Jira-Cloud-board/qaq-p/2798140

And, definitely check out the support documentation from ScriptRunner's vendor: https://docs.adaptavist.com/es/latest/enhanced-search-jql-functions

[Bartek Szajkowski _ Orbiscend OU]

Hello @Nguyen tuan anh 

Hope my late answer will help you :)

I'm Bartek, from Orbiscend OU - ARGON Powerful JQL Search

If you are open for third-party app, I would like to recommend our ARGON app.

To find issues commented by a specific user, you could try use the ARGON commented function with the author parameter instead of comment ~ USERID.

Furthermore, with options like start_date, end_date, contant and others option, you should find suitable solution for you.

 ARGON Powerful JQL Search 

Hope it will be helpful for you.
Greetings
Bartek