Hey

Have anyone stumpled across a plugin that adds the JQL Function "Group By".
So that issues can be group by certain fields.

Much like the "order by" function.

5 answers

1 accepted

This widget could not be displayed.

Here are some plugins (unfortunately commerical (ie cost money)) that should do what you want.

Crystal Reports

https://marketplace.atlassian.com/plugins/plugin.jcry

Business Inteligence

https://marketplace.atlassian.com/plugins/EAZYBI

This widget could not be displayed.

No, and I don't think it's actually possible. JQL is not SQL.

The reason is tha there are two parts to what you're doing in Jira. There's "give me a list of issues matching question" and then "show me the list". When you interrogate a database with SQL, you're doing both the question and display in one go. In Jira, you've got a filter answering the question, and then you push the list of issues (note - NOT all their data, a filter only returns a list of pointers to issues) through the issue navigator, an excel download, a gadget, a chart, a report and so-on.

The only reason "order by" works is because filters have a slight blur on the question/display barrier - they can also hold a simple flag saying "sort by these fields", and the "order by" clause feeds into that. The display methods are then free to use or ignore those if they want. I think to get a "group by" clause to work, you'd either need to extend that functionality, or have fields available that you could push into the "sort by" columns.

Further, to get your output to work, you'll have to modify the code generating the output - if you want that in the issue navigator, you're going to have to hack the issue navigator to understand the group-by stuff you add.

Or, you could look at something like the release notes, or filter gadgets, which take the filters they're given and do the "group by" internally because that's what they're for.

This widget could not be displayed.

JQL is not a generic query language. If you give some examples of the queries you would like to do that would help a great deal. The are features in JQL as well as plugins that act like limited group by clauses.

This widget could not be displayed.

Fx. "project = test AND status != closed Group By assignee"
this should return the issues within test project, that have not been closed (Pretty straigt forward)
BUT they should be display in groups sorted by the assignee.

Person 1:

test-1
test-2
Person 2:

test-3
test-4

like this. So its like "order by", but the order by field, should be a headline over issues.

This widget could not be displayed.

Thank you for clarifying because an order by clause will get the records listed in the proper order, but not formatted. Even in the sql world would not do what you want by sql alone. That type of formatting is done by report writers or report writer features built into sql query applications.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

83 views 0 1
Join discussion

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