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

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

2 votes

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.

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.

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.

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

171 views 1 10
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