Can I filter by last person commenting?

[Laura Merino Diez]

I was looking at a filter for issues updated a month ago or longer. Then I used the bulk edit to making a comment about closing those issues. 

What I did not realize (silly me!) is that that by commenting I was losing that filter (since I updated all those issues. 

Is there a way to:

1-Undo my bulk edit?

2-filtered for issues last commented by me or commented at a specific time?

Thanks!

[Geethanjali Katagani]

Hi @Laura Merino Diez ,

This is not possible via standard Jira,but an app which enhances JQL search functions will be 

able to do this, such as Scriptrunner.

For example, 

if you're using Jira Server/DC, Scriptrunner's JQL like this:

issueFunction in commented("by use.name after 2023-07-09")

or if you're on Jira Cloud:

commentedOn in ('2023-01-01','2023-10-11') AND commentedBy = currentuser()

Reference:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Search+Extensions+Server+Data+Center#JQLReference(Server)-Comments

Regards,

Geethanjali

[Charlotte Santos -Appfire-]

Hi @Laura Merino Diez 

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

Unfortunately, using vanilla JQL, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find issues last commented by you in a certain period of time:

commentLastCreatedBy=currentUser() AND commentedOnDate >= "2023/08/01" AND commentedOnDate <= "2023/09/30"

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,

Charlotte

[Mohamed Benziane]

Hi,

You could try to search these issue using the updateBy function

issue in updatedBy("")

If you have Scriptrunner Enhanced you can do this

lastCommentBy in ('012345-678912-34567-891011', '012345-678912-34567-891012')

https://docs.adaptavist.com/es/latest/features/jql-keywords#lastcommentby

You can also try to seach for a comment in these issue that contains specif word

comment~"My word"

[Hannes Obweger - JXL for Jira]

HI @Laura Merino Diez

I don't think that this is possible in plain Jira/JQL; to the best of my knowledge, you'll need extra tooling for that.

• You should be able to store the last comment date and commenter into dedicated fields using Jira Automation, and then use these fields to filter; this article should be a good starting point. 
• There a couple of apps in the Atlassian Marketplace that extend JQL by various functions, including comment-related ones. Scriptrunner has been mentioned before; I have used JQL Search Extensions a couple of times and it works well.
• There's other apps that have their own mechanisms for viewing and searching through issues. I myself work on such an app, in which finding the relevant issues would be a matter of clicks. I'll provide more information below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on the last point, this is how this would look in 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 number of so-called smart columns that aren’t natively available, including last comment, last commented by, date of last comment, and many other comment-related columns. 

As you can see above, you can easily sort and filter by these columns, and also use them across JXL many 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!