Is there a plug-in where we can filter the following?

[Rafik Bouizergane]

Is there a plug-in where we can filter the following?
All tickets where the last comment is not from person X
All tickets on which a person made a comment

[Romy Greenfield · Accepted solution]

Hello @Rafik Bouizergane ,

You can use Enhanced Search to do this. It is available on the Atlassian marketplace.  

We have a keyword called lastCommentBy and commentedBy which would be able to get you the information you needed. 

For example:

All tickets where the last comment is not from person X

lastCommentBy != <accountId of person X>

All tickets on which a person made a comment

commentedBy = <accountID of person X>

We have lots of other keywords and functions to help you and our docs are located here. We also have an introduction video here. 

This functionality is also available as a sub feature of ScriptRunner for Jira, which has a whole bunch of other useful features.

Let me know if you have any questions!

Best regards

Romy

[Yuliia_Borivets_[SaaSJet]]

Hi @Rafik Bouizergane 

You can try to do both queries with the Activity Streams Gadget (built-in option).

1. Filter by account ID (type in the person's name): Account ID is/is not

2. Filter activities: Activity is Comment added.

And press 'Save'.

If you want a plug-in, I can suggest one from my team. Issue History for Jira allows you to filter by updater and monitor changes made to any field, including comments. Export to CSV/Excel is also available.

Let me know if you have any questions.

[Rafik Bouizergane]

Hi @Yuliia_Borivets_[SaaSJet] 

Can you also filter the following let the plug-in? All tickets where the last comment is not from person X
Because we work with a team of about 10 people. And when we are doing the ticket grooming, we can apply this. So that we can see who last commented when. So that we can make sure that customers always get a response.

Thanks in advance!

[Yuliia_Borivets_[SaaSJet]]

With the Issue History plugin, you can only see all comments history for specific team member/ members who updated the ticket. If you want to exclude some person, it's better to try Activity Stream Gadget that I mentioned also.

[Hannes Obweger - JXL for Jira]

Hi @Rafik Bouizergane

my team and I are working on an app that should be the perfect fit for you: 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 wide range of so-called "smart columns" that aren’t natively available, including all commenters, the last commenter (a.k.a last commented by), and many other comment-related data. 

This is how it looks in action:

As you can see above, you can easily filter your issues based on commenters, 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 created your view, 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

[Aron Gombas _Midori_]

There are apps that add this capability to the JQL or you can export your issues and the comments on those to Excel and use the filters in Excel:

As you see commenter, comment date and comment text go to separate columns which makes filtering easy.

[Rafik Bouizergane]

Which apps?

[Aron Gombas _Midori_]

Oh, sorry the link in my answer below broke. So you should check the first apps in this list, all those seem to offer JQL extensions (fields or functions) you can use to filter by comments/commenters/etc.: 

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=comment%20jql