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'm trying to find an option using JDL to generate a report of comments (latest or by specific dates) for specific set of issues. However, I'm unable to find such an option within JQL. Can someone help?
Just to confirm, you want to be able to search by last comment date, and view the last comment made?
If so, this isn't a native piece of metadata - and JQL needs this to filter by it.
You could create this though using a custom field and Automation?
This is how I'd do it:
You'll need to be a Product Admin for this one:
Rule 1 - Future Issues
This rule will update these fields in future, when new comments are made:
Rule 2 - Existing Issues
This rule will look at all existing Issues and update these fields.
I'd consider limiting the JQL to relevant issues (eg. open issues, issues created in 2023, etc), just so you don't overuse your executions for the month.
The settings for Scheduled are also not relevant - you only need this rule once.
Once you have created and published this rule, press the blue Run rule button to run it immediately.
Once complete and you've checked the data is accurate, you can deactivate/delete the rule, as Rule 1 will hand all future comments.
A few extra notes...
Let us know if this helps!
If you look for an easy solution, with the Better Excel Exporter app you can just use this export type:
...to produce an Excel report from the issue fields you selected plus the comments (who, when and text):
(Discl. this is a paid and supported app developed by our team. Free for 10 users.)
just to add to Stephen's answer: If you're open to solutions from the Atlassian Marketplace, this would be trivial 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 number of so-called smart columns that aren’t natively available, including the latest comment (along with many other comment-related columns). This is how it looks in action:
As you can see above, you can easily sort and filter by the last comment, and also use it across JXL's many advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.
This all just works and doesn't need any scripting or Automation whatsoever.
Any questions just let me know,