> 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.
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
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.