Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,456,481
Community Members
 
Community Events
176
Community Groups

Sort by number of comments on a JQL

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. 

1 answer

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:

number-of-comments-v2.gif

(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,

Best,

Hannes

Thank you @Hannes Obweger - Fine Software - JXL 

I will look into this solution. 

Awesome - any questions just let me know!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Atlassian Community Events