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?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Whitney Bell ,
Have you tried the Two Dimensional Filter Statistics Gadget?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 Cloud -> plans.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.