83053 - summary report for columns of bug list page

Status: RESOLVED WORKSFORME

(Bugzilla :: Query/Bug List, enhancement, P4)

Description

[Andreas Franke (gone)]

This is a feature request. 

Currently, on the bug list page, you can click on the column header to sort the
list by the selected column. It would be nice if there was a possibility to
select a column and get the distribution of bugs across the values of the
selected column as a summary report.

Example:
The bug list shows the bugzilla.mozilla.org bugs with the 4xp keyword.
You invoke the new mechanism for the assignee/owner column, and the result is:
     45 [e-mail]
     26 [e-mail]
     17 [e-mail]
     17 [e-mail]
    ... ...

This feature does not make sense for columns where different bugs always have
different values, e.g. bug_id, summary, status_whiteboard(?), keywords,
but is is useful for owner, bug_status & resolution, component, ...

You could either have an additional "group by" link for each column where this
feature is supported, or have one menu to select the column and a submit button.
Or you could overload the link that is already present, so that if you click on
the column for the second time (when the bug list is already sorted by this
column), then it switches to the summary report. But the overloaded behaviour
might be hard to discover.

The summary report should be sortable by each column: by count, and by the value
the bugs are grouped by. This could be done the same way it is done in bug
lists: clicking on the column header sorts by the selected column.

Comment 1

[Andreas Franke (gone)]

Attachment: small, quick & dirty patch that gets you part of the way

Comment 2

[Andreas Franke (gone)]

Attachment: same patch (to buglist.cgi), but this time as diff -u

Comment 3

[Andreas Franke (gone)]

The above little patch simply counts the bugs for each owner during bug list
creation, and prints a summary table at the end of the page. 

Known problems with this patch:
- only works for "owner"
- doesn't support sorting
- summary is always displayed, not only on demand

If someone has an idea how to proceed from here, please comment.
BTW, the patch works fine with the current CVS tip.

Comment 4

[Dave Miller [:justdave]]

targetting all bugs with patches so they show up on the radar.

Comment 5

[Jacob Steenhagen]

-> New Bugzilla Product

Comment 6

[Andreas Franke (gone)]

See also bug 77764 "Allowing to do bug counts from the query page".

Comment 7

[Gervase Markham [:gerv]]

Another patch which adds function which is a subset of the general reporting patch.

Gerv

Comment 8

[Andreas Franke (gone)]

-> default owner. (Pulling myself out.)

Comment 9

[Gervase Markham [:gerv]]

Generic reporting is still on the 2.16 train; and even if it falls off, we'll
probably wait for that rather than do this.

Gerv

Comment 10

[Bradley Baetz (:bbaetz)]

Comment on attachment 36324 [details] [diff] [review]
same patch (to buglist.cgi), but this time as diff -u

needs-work because its pretemplatisation.

I also don't like the way this is part of the results; it should be mreged into
reporting, or something.

Comment 11

[Dave Miller [:justdave]]

*** Bug 224940 has been marked as a duplicate of this bug. ***

Comment 12

[Dave Miller [:justdave]]

enhancements without current patches are being pushed to 2.20

Comment 13

[Dave Miller [:justdave]]

Bugzilla 2.20 feature set is now frozen as of 15 Sept 2004.  Anything flagged
enhancement that hasn't already landed is being pushed out.  If this bug is
otherwise ready to land, we'll handle it on a case-by-case basis, please set the
blocking2.20 flag to '?' if you think it qualifies.

Comment 14

[Max Kanat-Alexander]

This is possible now with report.cgi.