JQL query to filter issues commented by any particular user

[Revathi R K]

I need to get the JQL query to filter issues commented by any particular user in Jira cloud.

We dont have scriptrunner plugin installed so could not use IssueFunction.

Thanks.

[Trudy Claspill]

Hello @Revathi R K 

Welcome to the Atlassian community.

Jira does not natively support filtering issue based on comment authors. To satisfy that requirement you will have to use a third party app. Are you willing to consider acquisition of an app to satisfy your requirement?

[Hannes Obweger - JXL for Jira]

Hi @Revathi R K

if you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called smart columns that aren’t natively available, including all commenters. 

This is how it looks in action:

As you can see above, you can easily sort and filter by your smart columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes

[Prosper Agwegiokhe]

Hi @Revathi R K ,

I’m Prosper, a support engineer at Appfire, and I’m here to help you.

The app I work for, JQL Search Extensions for Jira, you can use the query below to find all issues commented by a particular user:

commentedByUser = "{user's name}"

You can see more information about this query here, and please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Prosper.