Is it possible to group search results please?

[Helen Snowball]

I have a favourite filter for bugs which returns the data that I want according to the criteria in my query, however, while I can see how to order the returned data, I was hoping to also be able to group the search results by say Priority or Status....is this possible please?

[Jack Brickey · Accepted solution]

Hi Helen, welcome to the Community. What do you mean by "group" or rather how is it different? For example, if you click on the header of say Priority it will sort by priority 'grouping' the High, Medium, Low...

what would you prefer it to do?

Maybe you want to see sums of groups, e.g. # issues w/ High, Med, Low priorities? If so consider the two dimensional gadget on the dashboard and use priority for y-axis and maybe status for x-axis.

[Helen Snowball]

Hi Jack, thanks for picking up my question.

What I want it to do is as follows...

Within my search results I have bugs across different test levels, statuses (sp!), priorities, system components etc. Columns for each shown in my search results.

I can order by Priority then raised on date for e.g., but what I want to be able to is group my results by test level, then order by priority for e.g., rather than having to run multiple searches, one for each test level.

Or I might want to group by Status, then order by Priority so I can see at a glance how many I have still to be fixed against those awaiting retest and see easily the priority bugs at each status.

(We have just moved from using HP ALM and this is something I used to use a lot in ALM.)

Many Thanks

[Jack Brickey]

so i'm not sure how "test levels" is manifested in your project but if it is a field the why would the following not work?

...ORDER by "test levels" ASC, status DESC, priority DESC

sorry, i'm sure I'm overlooking something obvious here. :-(

[Mehmet A _Bloompeak_]

Hi @Helen Snowball ,

I couldn't visualize "group by status" and "order by priority" together. When you group by status you will end up with a table similar to the below

|Status    | Issue Count |
|ToDo      | 30          |
|InProgress| 12          |
|Done      | 10          |

You can not order the above table by priority.

Maybe what you are looking for is "group by status and priority". Then you will end up with a table similar to the below. Is it the one you are looking for?

|Status    | Priority |Issue Count |
|ToDo      | Minor    |10          |
|ToDo      | Major    |20          |
|InProgress| Minor    |10          |
|InProgress| Major    |2           |
|Done      | Minor    |3           |
|Done      | Major    |7           |