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 am looking to sort the fewest to greatest number of comments in Jira using JQL to create a filter for a team member to work from.
Ideally, this would be so that we can follow up on tickets that have not been followed up on enough. I see that I can make a bubble chart containing # of comments but I have not found any other way to sort- it within Jira.
Hi @Mary Junkin
welcome to the community!
to the best of my knowledge, this isn't available in "plain" JQL; you'd either need an extension from the Atlassian Marketplace, or utilise Jira Automation to write the number of comments into a custom field.
As an example for the former, if you're open to solutions from the Atlassian Marketplace, this would be easy to do with the app that my team is 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 "smart columns" that aren't natively available, including the number of comments.
This is how it looks in action:
(It's worth noting that JXL can do much more than that: From support for issue hierarchies, issue grouping, and sum-ups, to conditional formatting.)
This is really just one example for a Marketplace app that might solve your use case; there may be others. You may already know that you can trial any app for free for 1 month, and depending on the size of your site, it may be free forever. So perhaps try out a few and see which one works best for you.
Hope this helps,