How to count the number of comments in JIRA

Question

I want to create an Issue Filter that shows me the number of comments per issue, and then sorts by that.

I tried something like:

project = "myProject" AND created >= 2012-06-01 AND created < 2012-08-01 ORDER BY count(comment)

I'm on JIRA 4.2. How do I do this?

Sizzle

Answer 1

The easiest way I can think of is to use the JIRA Toolkit Plugin (by Atlassian) which will add a custom field for counting comments:

Than you could use the JQL to sort by the number of comments. For example, if the custom field is called Comments count, use the following query:

project = "myProject" AND created >= 2012-06-01 AND created < 2012-08-01 ORDER BY "Comments count"

Stigmatism

Works great! Just don't forget to import those nice custom fields into some of your field configurations. Just installing the plugin won't make them appear by magic. And then you must also reindex your JiRA instance so that those new calculated fields are well, calculated. Otherwise your range queries will return nothing. – Stoneman