Counting the number of components attached to a Jira issue

Is there a way in JQL to count the number of components attached to an issue?

3 answers

1 accepted

So I got this working with the JIRA Misc Custom Fields plugin.

Creating a new custom field (Calculated Number Field), using the following formula in the field description:

<!-- @@Formula: (issue.get("components") != null) ? issue.get("components").size() : 0 -->

For some reason this gave me issues when I configured the field to a specific issue type. When I configured it for Global (all issue types) it showed up in my issue navigator columns, and I can reference the field in the JQL editor.

Sorting the "counted" result is somewhat strange. It seems 0 is greater than any other number. I can live with this though.

1 vote

As Christian says. You could add a scripted field which calculated the number of components, which you don't need to put on any screens. Not ideal for ad hoc reporting though.

The other thing to do would be to hit the db directly... far from ideal.

Thanks for the reply.

I got a little further with the Calculated Number Field from the JIRA Misc Custom Fields plugin. I used the formula <!-- @@Formula: issue.get("components").size() --> in the field description (as pr. the documentation)

When I go to Issue Navigator -> Configure columns to add my new "count components" field, it will show a 10 issue preview with data, where the count value is shown correctly in the new column.

When I go back to the issue naviagtor, the new column has disappeared. I cannot reference the new field in a JQL query either. So it seems the field is doing what I want - I just cannot get the result where I want it.

I'll keep poking around. Any feedback is much appreciated!

I was talking about a scripted field from the script runner plugin, I'm not qualified to speak to the one you used I'm afraid.

Ok, thanks Jamie. I will be sure to check out the script runner plugin!

None that I would know of. I mean JQL is sth. like a WHERE clause. You don't have functions like SUM so you can't count.

Suggest an answer

Log in or Join to answer
Community showcase
Alexey Matveev
Published Saturday in Jira

How to run Jira in a docker container

Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...

194 views 6 8
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot