Re: [rt-users] Information how long a ticket stayed in the NEW state

2011-09-29 Thread Ruslan Zakirov
On Thu, Sep 29, 2011 at 1:18 PM, Adrian Stel  wrote:
> Hi,
>
>
>
> I need help with getting from RT the information how long a ticket
> stayed in the NEW state.

It's time interval between Started and Created dates.

> We have:
> Activity Reports
> JS Gantt extension
>
> but there is missing this information information.
>
> Any idea, perhaps we could check this in data base but where ? Table ?
>
> RT 3.8.8 Debian repository.
>
> --
> Best Regards
> Adrian Stelmaszyk

-- 
Best regards, Ruslan.

RT Training Sessions (http://bestpractical.com/services/training.html)
*  Chicago, IL, USA  September 26 & 27, 2011
*  San Francisco, CA, USA  October 18 & 19, 2011
*  Washington DC, USA  October 31 & November 1, 2011
*  Melbourne VIC, Australia  November 28 & 29, 2011
*  Barcelona, Spain  November 28 & 29, 2011


[rt-users] Information how long a ticket stayed in the NEW state

2011-09-29 Thread Adrian Stel
Hi,



I need help with getting from RT the information how long a ticket
stayed in the NEW state.

We have:
Activity Reports
JS Gantt extension

but there is missing this information information.

Any idea, perhaps we could check this in data base but where ? Table ?

RT 3.8.8 Debian repository.

-- 
Best Regards
Adrian Stelmaszyk

RT Training Sessions (http://bestpractical.com/services/training.html)
*  Chicago, IL, USA  September 26 & 27, 2011
*  San Francisco, CA, USA  October 18 & 19, 2011
*  Washington DC, USA  October 31 & November 1, 2011
*  Melbourne VIC, Australia  November 28 & 29, 2011
*  Barcelona, Spain  November 28 & 29, 2011