Report for Time usage

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Report for Time usage

Dan Holmes
Am i just not see this?  I want a report that shows by component across
procducts a sum of the time used by month.

Is this in bugs or do i need to break out my PHP editor and read from MySQL?

dan
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Report for Time usage

Gervase Markham
Dan Holmes wrote:
> Am i just not see this?  I want a report that shows by component across
> procducts a sum of the time used by month.

There's no such report, I'm afraid. There's a bug on this somewhere.

Gerv
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Report for Time usage

Dan Holmes
Gervase Markham wrote:

> Dan Holmes wrote:
>
>> Am i just not see this?  I want a report that shows by component
>> across procducts a sum of the time used by month.
>
>
> There's no such report, I'm afraid. There's a bug on this somewhere.
>
> Gerv

This one? https://bugzilla.mozilla.org/show_bug.cgi?id=192814

In my case i am using bugz as a support site too.  At the end of the
month i need a sum of the hours of bugs CLOSED by Product (customer in
real life) of the bugs in the component "Support".

Is this something that would fit in the bug above or is that too
specialized?

While i am asking here is the SQL for what i need.  Did i do it right?

SELECT `products`.`name` , sum( `bugs_activity`.`added` )
FROM `components` , `products` , `bugs` , `bugs_activity`
WHERE `components`.`name` = 'Support' AND `components`.`product_id` =
`products`.`id` AND `bugs`.`product_id` = `products`.`id` AND
`bugs`.`component_id` = `components`.`id` AND `bugs_activity`.`bug_id` =
`bugs`.`bug_id` AND fieldid =45
GROUP BY `products`.`name`


What i wasn't sure about was the fieldid = 45.  That seemed to be the
hours added.  I kinda expected the hours to be in the bugs table along
with the estimated and remaining time but i didn't see it there.

dan
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools
Reply | Threaded
Open this post in threaded view
|

Re: Report for Time usage

Gervase Markham
Dan Holmes wrote:
> Is this something that would fit in the bug above or is that too
> specialized?

Feel free to file another bug if you'd like.

> While i am asking here is the SQL for what i need.  Did i do it right?

I don't know; I know very little about the time tracking implementation.

Gerv
_______________________________________________
mozilla-webtools mailing list
[hidden email]
http://mail.mozilla.org/listinfo/mozilla-webtools