I think there's a missing question here, but I suspect the question is either
1) Does JQL have a "group by" clause? To which the answer is "no", because JQL is for finding issues, not displaying the results of the search
2) For internal users, the SQL for groups is simply "have a look at the membership_base table"
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG