How to show Issues with 2 components twice in a filter

Norman Ortmann June 29, 2017

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

 

 

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 29, 2017

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.

Suggest an answer

Log in or Sign up to answer