developer work summary gourped by reporter

[mortee]

Developer Work Summary report seems to be grouped by reporter. However, I guess it's assumed that the owner (or assignee) of the ticket does the work, not the one who reports the task/problem. So I guess it should be grouped by owner - at least I changed the SQL on my instance.

[Russ Tyndall]

I'm not quite sure what you mean. The developer work summary is based on the "author" field of ticket change, which is the person that added the hours to the ticket (not the owner or reporter of the ticket). Not sure why it would make sense to group the hours based on ticket owner, rather than the person who actually added the hours, so for now I am closing as invalid. If you have more data, please feel free to continue the discussion.

Incidentally (re #7368) the reason that some of the reports are time based and some are not is because the "Billing reports" are centered around the ticket_change table where each change affecting a ticket are stored, while the "Ticket/Hour Reports" are centered around the ticket and ticket_custom tables (where aggregates are stored, ie: the total hours and estimated hours fields).

[mortee]

Well, sure, I got this wrong. I'm just getting familiar with basic Trac internals, so I confused the two tables, and their fields. My bad, sorry.

[Russ Tyndall]

Cool, glad we got it straight! Thanks again for the good bug reports, which have always been essential to this plugin working so widely.