You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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?
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.
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()
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!
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')
You can also try to seach for a comment in these issue that contains specif word
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.
Hope this helps,
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!