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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,981 views 12 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot