How to count the number of comments in JIRA

jira jql
Huey picture Huey · Aug 5, 2012 · Viewed 10.5k times · Source

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

Kuf picture Kuf · Aug 5, 2012

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:

number_of_comments_field

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"

Related questions

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this …

Read More
JIRA: Searching for all issues with a given link type

Is there a way to query for all issues with a particular link type? For example, let there be a dependency link where an issue can "depends on" another issue. Is there a query to find all issues that depend …

Read More
How do I query Jira to search for all issues that have been resolved within a length of time from when it was created?

For example, let's say I need to find all issues that were resolved within 1 week's time. I need something like: resolved - created < '1w' Another example: Let's say I have 3 issues: 1) created 2 days ago, resolved 1 day ago. 2) created 5 …

Read More