Auto calculate time (estimaded, remaining)

RT Users
1

Hi, I am a new RT user and I have 2 tasks to do.

  1. A user creating a ticket, can set the time worked and the time
    remaining, but not the time estimated (by default), I want to set the
    time estimated = the first time remaining + the first time worked.

and

  1. When a user insert a “time worked” on a comment or reply, I want to
    decrement the time remaining (time remaining = Time estimated - Total
    Time worked)

The number 1 ocurs only on a ticket creation and number 2 every entry of
a time worked.

I never programmed in perl or sql, so I can not risk doing my first
codes in my RT-database.

Could someone help-me showing how I can do that, where can I learn, and
some samples of codes.

Do I solve this problem in command-line or in the web-interface of RT?

PS. I�m using rt 3.2 + apache1 + postgress

Thanks in advance

humberto.vcf (268 Bytes)

2

I am really perplexed and just want to know (and I apologise Junior this is
not directed at you I’ve seen it far to many times now- just I am in that
frame of mind)
you are saying that you never programmed perl or sql , how did you get the
job in maintaining a ticketing system based on perl and sql …
I don’t mean any offence … I would like to know the secret so I can get a
job above my skills …
RoyFrom: “Humberto Junior” humberto@nexos.com.br
To: rt-users@lists.bestpractical.com
Sent: Tuesday, November 22, 2005 6:46 PM
Subject: [rt-users] Auto calculate time (estimaded, remaining)

Hi, I am a new RT user and I have 2 tasks to do.

  1. A user creating a ticket, can set the time worked and the time
    remaining, but not the time estimated (by default), I want to set the
    time estimated = the first time remaining + the first time worked.

and

  1. When a user insert a “time worked” on a comment or reply, I want to
    decrement the time remaining (time remaining = Time estimated - Total
    Time worked)

The number 1 ocurs only on a ticket creation and number 2 every entry of
a time worked.

I never programmed in perl or sql, so I can not risk doing my first
codes in my RT-database.

Could someone help-me showing how I can do that, where can I learn, and
some samples of codes.

Do I solve this problem in command-line or in the web-interface of RT?

PS. I�m using rt 3.2 + apache1 + postgress

Thanks in advance

The rt-users Archives

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Download a free sample chapter of RT Essentials from O’Reilly Media at
http://rtbook.bestpractical.com

WE’RE COMING TO YOUR TOWN SOON - RT Training in Amsterdam, Boston and
San Francisco - Find out more at
http://bestpractical.com/services/training.html

3

Hi Raed

I am a trainee, and I work in infra-structure of my company (decide whate
and where buy hardware, suport the staff using linux, updating the
servers: freebsd,linux), I had a experience using RT, and I sugested to
use RT here, they liked and now I’m the “man of RT”.

Here RT will feed the data base for other aplications that will read (only
read) the tables and make some reports, very little work…

Only this, I dont have the JOB of maintaing the ticketing system, i am a
trainee wanting to show the boss RT working beautifully.

Can someone help-me?

4

Hi,On Tue, 2005-11-22 at 20:46, Humberto Junior wrote:

  1. When a user insert a “time worked” on a comment or reply, I want to
    decrement the time remaining (time remaining = Time estimated - Total
    Time worked)

I found a solution to this. I just published my solution in the wiki:

http://wiki.bestpractical.com/index.cgi?UpdateTimeLeft

My local Update.html is attached for your convenience.

Hope this helps!

Mikko Lipasti
Polarcom Consulting Oy

Update.html (8.55 KB)