How to show Issues with 2 components twice in a filter

[Norman Ortmann]

Hi Guys,

in my team we have the problem that we have issues with multiple components. So far we exported them to Excel and them devided them up for a report.

As we know now what is going on we want to optimize our working approach. We want to show how often which component is used in our project and in which status the issue is.

Does anyone know an JQL-Query which allows this kind of filtering?

Thanks a lot.

Cheers Norman

[Nic Brough -Adaptavist-]

You can't do this with JQL.

JQL finds issues, it doesn't do reporting or sorting of these, it's just a simple list of matches.  An issue will only appear once on a list, because that's what people expect from a search.

A simple export to excel is only able to dump out the list, it can't know the reasons for each hit.

But.  You can report on it inside JIRA.  I'd create a dashboard and add a "filter statistics" gadget to it, with a statistic of "component".  You'll get one line for each component, with a count of the issues in it, and the link to a filter for that.  For a bit more "clever", try the same with a "2 dimensional" grid.