JQL Group By function

Mikkel Kragelund Nielsen
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 30, 2012

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

3 votes
Answer accepted
Norman Abramovitz
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 30, 2012

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
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.
May 30, 2012

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.

0 votes
Norman Abramovitz
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 30, 2012

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.

0 votes
Mikkel Kragelund Nielsen
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 30, 2012

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.

0 votes
Norman Abramovitz
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 30, 2012

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.

Suggest an answer

Log in or Sign up to answer