192814 - Reporting on time (bugs_activity)

Status: RESOLVED WORKSFORME

(Bugzilla :: Reporting/Charting, enhancement)

Description

[Jurgen Botz]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20021130

Now that Bugzilla has time tracking there's a need for reporting on time spent,
i.e. a report for a range of time that has i.e. "owner" on one axis, "bug_id" on
another, and time spent rather than bug counts in the intersections, plus totals
at the bottom.

Also useful would be a comprehensive activity listing, i.e. all activity sorted
by owner and bug over a range of time with summary totals for each bug or product.


Reproducible: Always

Steps to Reproduce:
1.
2.
3.

Comment 1

[Gervase Markham [:gerv]]

One way of implementing this would be to get reports.cgi to do it. It can
already restrict your search to "bugs whose Hours Worked has changed between
dates X and Y", which is good. But, you'd need to:

- make it so that a particular bug could appear in more than one cell
- make it so that, instead of displaying the number of bugs in the cell, it
displayed the result of a query on those bugs only.

The first might be achieved by removing the GROUP BY (bugs.bug_id) clause from
the SQL generated by Bugzilla::Search. However, this might have side-effects.
One side effect would be that many of the calculated totals on the display page
would be meaningless.

The second would probably have to be implemented using a set of canned queries,
chosen using a radiogroup. The default would be "bug counts", which would be a
no-op. The others would map to the ability to do an SQL query: "SELECT SUM/COUNT
<something> from <somewhere> WHERE bugs.bug_id IN (<list of IDs>)". The value
returned would then be substituted for the bug count in the table.

That's all I have for now.

Gerv

Comment 2

[Antony Chen]

I'm surprised that no one has pushed for this sooner if the time tracking has
been in the system since 2003.  Use of reports.cgi is no longer valid.  I think
using chart.cgi is more appropriate as you could chart time usage for a specific
component and/or product group.  I'm somewhat new to Bugzilla and only started
using it, but I'm not entirely sure putting this functionality in chart.cgi is
appropriate since the new charting kitchen seems to revolve more around # of bugs.

However, looking at the data that is collected by collectstats.pl, it seems
natural, at the very minimum, that time spent, time actuals, and change is
stored alongside this data.

Comment 3

[Frédéric Buclin]

Time-related stuff is handled by summarize_time.cgi, which exists since Bugzilla 2.20. It doesn't make sense to hack chart stuff to support this.