nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JQL filter for issues with more than x comments?

Jason J. Fedelem

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.

Any ideas?

Accepted answers

Jack Brickey

Hi @Jason J. Fedelem ,

There isn't a specific JQL for comment count.

However, you might consider the following solution.

Create a custom number field, e.g. comment-count
Create a automation rule that triggers on comment added
Test if you're comment–count has reached your threshold. if not increment otherwise exit the rule.
Use JQL to find issues that have reached the threshold

Example, assume your threshold is 10. Now you can use the following JQL defined all issues that have reached your threshold.

comment-count = 10

All comments

Samuel Gatica _ServiceRocket_

Hi @Jason J. Fedelem

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

Best regards

Sam

Jack Brickey

Hi @Jason J. Fedelem ,

There isn't a specific JQL for comment count.

However, you might consider the following solution.

Create a custom number field, e.g. comment-count
Create a automation rule that triggers on comment added
Test if you're comment–count has reached your threshold. if not increment otherwise exit the rule.
Use JQL to find issues that have reached the threshold

Example, assume your threshold is 10. Now you can use the following JQL defined all issues that have reached your threshold.

comment-count = 10

mauricio.groth

Hi @Jason J. Fedelem

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!
Best regards,
Maurício

Jason J. Fedelem

This works without having to add more addon's or spend more money. Thanks!

Jason J. Fedelem

Thanks for your input!

Jack Brickey

great to hear it worked for you!

Jason J. Fedelem

Thanks for your input, I appreciate it.

Hannes Obweger - JXL for Jira

Hi @Jason J. Fedelem

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,

Best,

Hannes

Julie SANTINI

Hello,

I want to do the same thing. Can you explain more ? I work with kanban

Thanks,

Julie

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud