getting time unit to show in the tickets - status view

[offerlam]

Hi all

I'm trying to get time units to show as a column under tickets -> status view for both open and closed cases...

is this possible? i would assume it would require to fire off a SQL command against the DB but im not a DB guy

THANKS

Casper

[offerlam]

can no one help?

[crythias]

Time units is in a separate table and requires a sum of values for a given ticket id. It can be developed, but if nobody's responding, you probably won't get a better answer for the moment.

[offerlam]

ok... maybe you have a better solution to my problem..

what im trying to do is to make a easy way for my bookkeeper to make the bills to my clients...

so the way i figured i would do this was to say one time unit equals 15 min of work.. so when se sees the closed case and that 4 time units have been registered she knows she has to bill the client 1 hour of work..

i was hoping she could use the status view of all the closed cases so she could get a quick overview of how much a client should pay.. is there another way to solve this?

Thanks

Casper

[crythias]

yes. sql export. You can use the sql box to do this, or you could create a web page dedicated to the report...
viewtopic.php?f=60&t=12546