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?

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"