On May 23, 3:22 pm, Chris <[EMAIL PROTECTED]> wrote: > This is for those of you who have used this plug-in. I don't care if a > ticket is billable or not, so for tickets I've removed the Billable > checkbox (via trac.ini). I have just started added tickets and time > estimations and so far all Total Hours are 0. > > From the plug-in page on TracHacks, billing reports "Currently are the > only time based reports, and are therefore useful for getting an > estimate what tickets had times (and totals), and which developers > spent their time where." So for the Ticket Work Summary, Milestone > Work Summary, and Developer Work Summary does that mean those tickets > must be checked as Billable in order to show in these reports? When I > bring up either of these reports I get this error: > Report execution failed: (1054, "Unknown column '0' in 'order > clause'") > > Maybe it's me just but the information on the plug-in page really > isn't clear and doesn't offer much, especially for understanding how > the Management page works. Can anyone add some in-sight?
I had a different, but related issue. The summary of work remaining, used the estimates for a ticket, no matter what, even if the ticket was closed. so, if I had 10 tickets, estimated at 10 hours each, I had 100 hours of estimated work. if I did 5 tickets in 1 hour each, and closed them, my estimated time remaining was 95 hours (not 50) I had to go in and update the report queries. all this tool does as far as I can tell is add 3 custom fields, and some custom reports. however, a lot of other tools rely on 2 of those custom fields (estimate, and total hours) basically, you need to edit the reports. yoheeb --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
