It seems as though if I comment out the following line (3209) in /opt/otrs/Kernel/System/Ticket.pm that the full value of the ticket gets stored. I'll have to do some testing to see what happens if I enter a value with too many decimal places etc.
The line commented out is: # $TimeUnit = int{$TimeUnit}; Might this break something else that I might not be aware of? - Pete McDonnell Manager, Technical Services Hip Interactive > -----Original Message----- > From: Gerold Gruber [mailto:[EMAIL PROTECTED] > Sent: Friday, February 04, 2005 11:11 AM > To: User questions and discussions about OTRS. > Subject: Re: [otrs] Time Accounting > > In the installation I'm involved in we also use minutes > (integer) as time units. > At the end of the month a aggregate my units per ticket into > a list and add this as appendix to my invoice, 'cause I get > paid for handling tickets in this case. > > So I'm also 'raw' on the database: > select tn, customer_id, sum (time_unit) from time_accounting > ta , ticket t where ta.ticket_id = t.id and ta.create_by = 5 > and (ta.create_time >= > '2005-01-01 00:00:00') and (ta.create_time < '2005-02-01 > 00:00:00') group by tn, customer_id order by tn; > > 5 is just my user id > > Hth > > Gerold > > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > Support oder Consulting für Ihr OTRS System? > => http://www.otrs.de/ > _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/