Is there a JQL Equivalent to GROUP BY?

Whitney Bell August 2, 2021

Hello, 

I am trying to create a complex JQL query in our Company Managed Project and don't see an equivalent to SQL's GROUP BY keyword. Is there a JQL equivalent for this? 

3 answers

0 votes
Cornelius Gillner February 18, 2022

Hi @Whitney Bell,

you probably don't really need a GROUP BY if you're working in filters.

You can just order by multiple fields which then sorts everything in nice groups.

Try this and see if you like it:

resolution is EMPTY order by project, type, status, created

Mitesh Sharma December 16, 2022

that not completely true. try grouping by reporter.

like many other files this not available as a column or field or a group by in the JIRA plans  

Like Benoit BOUCHER likes this
0 votes
Carlos Garcia Navarro
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 2, 2021

Hi @Whitney Bell ,

Have you tried the Two Dimensional Filter Statistics Gadget?

0 votes
Mohamed Adel
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.
August 2, 2021

Hi @Whitney Bell 

Welcome to the community , JQL is a search functionally and doesn't support grouping. 

you have three ways to get the required information 

- Create a filter for  each group of the required data then add gadget to your dashboard 

- Use any reporting plugin like easybi

- Use plugin like JQL Search Extensions for Jira & reports 

 

Thanks in advance

Mohamed Adel 

Mitesh Sharma February 6, 2023

Thanks Mohamed.

Filter is not a available option at all time.

for example in JIRA Cloud -> plans, i can have a filter by Assignee but not Reporter !

 

if you can explain below are bug or missing features that would be appreciated:

1. Most of the fields are not available for filters JIRA Cloud -> plans.

1. Most of the fields are also not available for filter JIRA Cloud -> plans -> Timeline view -> View Settings -> Group By.

 

 

View Settings -> Group By

JIRA.JPG

 

 

JIRA Cloud -> plans.

JIRA_2.JPG.png

Suggest an answer

Log in or Sign up to answer