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 build a filter that exposes controversial cards. In our org, this is generally indicated by the number of comments as the discussion gets going. So I'd like to be able to filter for cards with more than x comments on them. So far I haven't found a way to do this.
Hi @Jason J. Fedelem ,
There isn't a specific JQL for comment count.
However, you might consider the following solution.
Example, assume your threshold is 10. Now you can use the following JQL defined all issues that have reached your threshold.
comment-count = 10
I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.
Unfortunately, using JQL of Jira, you’ll not be able to do it.
In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your tickets that have more than 3 comments
commentsCount > 3
Please contact our support if you have any other questions about this query.
We’ll be happy to help you!
Unfortunately, this is not feasible with the native Jira features, but this can be accomplished with the addon Comment Custom Fields for Jira (https://marketplace.atlassian.com/apps/1219476/comment-custom-fields-for-jira?hosting=cloud&tab=overview). Then you can use JQL to query the counter.
Hope this helps
I'm glad you got your use case solved! Just for future reference, if you're open to solutions from the Atlassian Marketplace, this would also be easy to do with the app that my team is working on, JXL for Jira.
JXL is a full-fledged spreadsheet/table view 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 number of comments (along with many other comment-related fields).
This is how it looks in action:
As you can see above, you can easily sort and filter by the number of comments, or apply advanced features such as conditional formatting. Once you've narrowed down your list of issues, you can work on these issues directly in JXL, trigger various actions in Jira, or export them with just one click.
Hope this helps,