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.
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.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot