Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is it possible to use in the search result - group by clause

I would like to use in my search the group by clause so that in my search if field is assignee then all tickets pulled out can be grouped by each assignee pulled and not just order by clause

3 answers

0 votes

There is no group-by clause.  A Jira Query Language (JQL) search returns only issues, no data, or manipulation of data.

It is up to where you use it to sort, group or whatever.  You'll need to find a report that supports grouping, not change the query.

0 votes
John Funk Community Leader Mar 21, 2019

Hi Anju,

Another option is to use the Issue Statistics gadget on a dashboard. Pull in your filter on the gadget and then put in Assignee for the Statistic Type value. 

Thanks John,

Being a new user in Jira I am not sure where is the Statistics gadget option.

I only see manage dashboard

John Funk Community Leader Mar 21, 2019

Yes, create a Dashboard first and then click on Add gadget. When the list comes up, choose the link Load all gadgets. Then select Issue Statistics. 

Thanks John, i created a new dashboard and did pull in my search query in it.

It shows a graphical presentation in % usage only , any other way i may expand what all the gadget may include for fields or data

John Funk Community Leader Mar 21, 2019

Not with that gadget, but you can use the same filter and use another gadget (I would add a second gadget) called Filter Results. With that gadget you can add multiple fields. 

Thanks John, the filter result gadget worked fine for me and am able to see selected fields base on assignee field

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...

225 views 1 4
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you